PREVIEW / etf_30min / 2009-12-08

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-08.parquet
  size:    236 KB
  rows:    7,870

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-12-08 04:30:00	SPY	ETF	111.16	111.16	111.16	111.16	1000.0
2009-12-08 05:00:00	SPY	ETF	111.12	111.18	111.12	111.18	200.0
2009-12-08 05:30:00	SPY	ETF	111.1	111.1	111.0	111.0	433.0
2009-12-08 06:00:00	SPY	ETF	111.0	111.0	110.65	110.65	19447.0
2009-12-08 06:30:00	SPY	ETF	110.65	110.65	110.18	110.38	30671.0
2009-12-08 07:00:00	SPY	ETF	110.31	110.31	110.05	110.18	319536.0
2009-12-08 07:30:00	SPY	ETF	110.17	110.2	109.8	110.06	883093.0
2009-12-08 08:00:00	SPY	ETF	110.04	110.15	109.93	109.94	1286757.0
2009-12-08 08:30:00	SPY	ETF	109.94	109.95	109.68	109.9	3168419.0
2009-12-08 09:00:00	SPY	ETF	109.9	110.13	109.83	110.07	1310635.0
2009-12-08 09:30:00	SPY	ETF	110.04	110.09	109.27	109.695	27789036.0
2009-12-08 10:00:00	SPY	ETF	109.73	109.98	109.61	109.8419	14056709.0
2009-12-08 10:30:00	SPY	ETF	109.84	109.91	109.48	109.7	11920082.0
2009-12-08 11:00:00	SPY	ETF	109.69	110.08	109.65	110.055	11520009.0
2009-12-08 11:30:00	SPY	ETF	110.06	110.25	109.92	110.0	10923003.0
2009-12-08 12:00:00	SPY	ETF	110.0	110.06	109.77	109.83	6140697.0
2009-12-08 12:30:00	SPY	ETF	109.83	110.01	109.76	110.0	4554769.0
2009-12-08 13:00:00	SPY	ETF	109.99	110.08	109.6	109.64	6855488.0
2009-12-08 13:30:00	SPY	ETF	109.63	109.93	109.63	109.8	5176852.0
2009-12-08 14:00:00	SPY	ETF	109.8	109.9	109.56	109.61	6262112.0
2009-12-08 14:30:00	SPY	ETF	109.61	109.75	109.39	109.465	10702641.0
2009-12-08 15:00:00	SPY	ETF	109.46	109.76	109.44	109.72	10489777.0
2009-12-08 15:30:00	SPY	ETF	109.71	109.78	109.51	109.64	17562185.0
2009-12-08 16:00:00	SPY	ETF	109.64	110.7724	109.46	109.53	9069240.0
2009-12-08 16:30:00	SPY	ETF	109.53	110.7725	109.42	109.47	7383247.0
2009-12-08 17:00:00	SPY	ETF	109.48	109.51	109.46	109.5	122904.0
2009-12-08 17:30:00	SPY	ETF	109.48	109.51	109.45	109.45	34000.0
2009-12-08 18:00:00	SPY	ETF	109.46	109.49	109.39	109.39	26531.0
2009-12-08 18:30:00	SPY	ETF	109.4	109.51	109.38	109.51	25275.0
2009-12-08 19:00:00	SPY	ETF	109.51	109.73	109.51	109.7	37691.0
2009-12-08 19:30:00	SPY	ETF	109.71	109.77	109.68	109.76	58534.0
2009-12-08 06:00:00	QQQ	ETF	43.88	43.88	43.86	43.86	3733.0
2009-12-08 06:30:00	QQQ	ETF	43.71	43.71	43.63	43.69	26433.0
2009-12-08 07:00:00	QQQ	ETF	43.67	43.67	43.58	43.58	310900.0
2009-12-08 07:30:00	QQQ	ETF	43.57	43.58	43.46	43.57	325131.0
2009-12-08 08:00:00	QQQ	ETF	43.56	43.61	43.55	43.55	403252.0
2009-12-08 08:30:00	QQQ	ETF	43.55	43.66	43.46	43.55	1008306.0
2009-12-08 09:00:00	QQQ	ETF	43.54	43.69	43.53	43.68	702665.0
2009-12-08 09:30:00	QQQ	ETF	43.68	43.68	43.36	43.54	17097337.0
2009-12-08 10:00:00	QQQ	ETF	43.54	43.69	43.47	43.64	7869274.0
2009-12-08 10:30:00	QQQ	ETF	43.635	43.67	43.48	43.57	6075024.0
2009-12-08 11:00:00	QQQ	ETF	43.57	43.82	43.55	43.81	7722050.0
2009-12-08 11:30:00	QQQ	ETF	43.81	44.0	43.79	43.91	6146757.0
2009-12-08 12:00:00	QQQ	ETF	43.92	43.96	43.8	43.83	2312792.0
2009-12-08 12:30:00	QQQ	ETF	43.83	43.9	43.8	43.9	2792026.0
2009-12-08 13:00:00	QQQ	ETF	43.89	43.91	43.74	43.75	2753558.0
2009-12-08 13:30:00	QQQ	ETF	43.75	43.88	43.75	43.83	3676525.0
2009-12-08 14:00:00	QQQ	ETF	43.83	43.8601	43.73	43.74	2290931.0
2009-12-08 14:30:00	QQQ	ETF	43.74	43.78	43.62	43.6425	5622689.0
2009-12-08 15:00:00	QQQ	ETF	43.65	43.76	43.645	43.74	4334084.0

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

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