PREVIEW / etf_30min / 2009-11-19

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-11-19.parquet
  size:    238 KB
  rows:    7,847

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2009-11-19 04:00:00	SPY	ETF	110.76	110.76	110.56	110.56	2750.0
2009-11-19 04:30:00	SPY	ETF	110.56	110.67	110.56	110.64	645.0
2009-11-19 05:00:00	SPY	ETF	110.59	110.69	110.57	110.69	600.0
2009-11-19 05:30:00	SPY	ETF	110.74	110.74	110.7	110.7	200.0
2009-11-19 06:00:00	SPY	ETF	110.71	110.71	110.55	110.55	3200.0
2009-11-19 06:30:00	SPY	ETF	110.54	110.54	110.32	110.33	145453.0
2009-11-19 07:00:00	SPY	ETF	110.36	110.44	110.26	110.38	198214.0
2009-11-19 07:30:00	SPY	ETF	110.4	110.5	110.25	110.5	292370.0
2009-11-19 08:00:00	SPY	ETF	110.48	110.92	110.34	110.35	1040296.0
2009-11-19 08:30:00	SPY	ETF	110.37	110.68	110.32	110.54	2392467.0
2009-11-19 09:00:00	SPY	ETF	110.54	110.63	110.49	110.51	1280496.0
2009-11-19 09:30:00	SPY	ETF	110.51	110.56	109.27	109.5	38596518.0
2009-11-19 10:00:00	SPY	ETF	109.5	109.75	109.35	109.65	26638964.0
2009-11-19 10:30:00	SPY	ETF	109.65	109.65	109.2	109.26	14046673.0
2009-11-19 11:00:00	SPY	ETF	109.26	109.39	109.13	109.38	10437525.0
2009-11-19 11:30:00	SPY	ETF	109.37	109.55	109.31	109.5184	7555734.0
2009-11-19 12:00:00	SPY	ETF	109.52	111.3059	109.46	109.585	8484672.0
2009-11-19 12:30:00	SPY	ETF	109.58	109.7	109.4101	109.52	7668813.0
2009-11-19 13:00:00	SPY	ETF	109.52	109.62	109.31	109.43	5784060.0
2009-11-19 13:30:00	SPY	ETF	109.42	109.65	109.41	109.58	5565318.0
2009-11-19 14:00:00	SPY	ETF	109.57	109.66	109.34	109.56	7896277.0
2009-11-19 14:30:00	SPY	ETF	109.56	109.82	109.54	109.675	9133722.0
2009-11-19 15:00:00	SPY	ETF	109.67	109.75	109.51	109.65	9052329.0
2009-11-19 15:30:00	SPY	ETF	109.65	110.0	109.57	109.8	22781533.0
2009-11-19 16:00:00	SPY	ETF	109.8	111.306	109.42	109.84	26374057.0
2009-11-19 16:30:00	SPY	ETF	109.85	109.93	109.7	109.74	547379.0
2009-11-19 17:00:00	SPY	ETF	109.72	109.78	109.71	109.71	22115.0
2009-11-19 17:30:00	SPY	ETF	109.72	109.73	109.71	109.71	3841.0
2009-11-19 18:00:00	SPY	ETF	109.7	109.72	109.61	109.69	39112.0
2009-11-19 18:30:00	SPY	ETF	109.65	109.73	109.65	109.65	13100.0
2009-11-19 19:00:00	SPY	ETF	109.65	109.8	109.65	109.76	11114.0
2009-11-19 19:30:00	SPY	ETF	109.77	109.88	109.77	109.82	31216.0
2009-11-19 04:00:00	QQQ	ETF	44.15	44.15	44.15	44.15	150.0
2009-11-19 05:00:00	QQQ	ETF	44.12	44.12	44.12	44.12	500.0
2009-11-19 05:30:00	QQQ	ETF	44.12	44.12	44.11	44.11	6500.0
2009-11-19 06:00:00	QQQ	ETF	44.13	44.13	44.05	44.05	6155.0
2009-11-19 06:30:00	QQQ	ETF	44.02	44.03	43.96	44.0	10258.0
2009-11-19 07:00:00	QQQ	ETF	44.0	44.04	43.97	44.03	117534.0
2009-11-19 07:30:00	QQQ	ETF	44.01	44.04	43.98	44.04	60431.0
2009-11-19 08:00:00	QQQ	ETF	44.02	44.12	44.01	44.02	850716.0
2009-11-19 08:30:00	QQQ	ETF	44.03	44.09	44.01	44.04	1016714.0
2009-11-19 09:00:00	QQQ	ETF	44.04	44.11	44.03	44.07	944725.0
2009-11-19 09:30:00	QQQ	ETF	44.06	44.08	43.45	43.55	23507066.0
2009-11-19 10:00:00	QQQ	ETF	43.55	43.64	43.52	43.58	15397202.0
2009-11-19 10:30:00	QQQ	ETF	43.582	43.582	43.4	43.412	9627152.0
2009-11-19 11:00:00	QQQ	ETF	43.41	43.47	43.35	43.46	7349844.0
2009-11-19 11:30:00	QQQ	ETF	43.45	43.53	43.44	43.53	3607257.0
2009-11-19 12:00:00	QQQ	ETF	43.5201	43.59	43.51	43.58	4571143.0
2009-11-19 12:30:00	QQQ	ETF	43.58	43.62	43.47	43.52	3090732.0
2009-11-19 13:00:00	QQQ	ETF	43.51	43.57	43.45	43.5	2784753.0

> showing 50 of 7,847 rows — these rows as CSV

> unlock the full archive -- $79 one-time