PREVIEW / etf_30min / 2010-01-11

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-01-11.parquet
  size:    246 KB
  rows:    8,255

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
2010-01-11 04:00:00	SPY	ETF	115.12	115.17	115.12	115.17	800.0
2010-01-11 04:30:00	SPY	ETF	115.17	115.17	115.17	115.17	100.0
2010-01-11 05:00:00	SPY	ETF	115.17	115.18	115.17	115.18	15000.0
2010-01-11 05:30:00	SPY	ETF	115.25	115.25	115.25	115.25	5000.0
2010-01-11 06:00:00	SPY	ETF	115.25	115.25	115.05	115.05	23600.0
2010-01-11 06:30:00	SPY	ETF	115.11	115.11	115.11	115.11	10000.0
2010-01-11 07:00:00	SPY	ETF	115.05	115.05	114.95	115.02	38054.0
2010-01-11 07:30:00	SPY	ETF	115.02	115.05	114.96	114.96	110296.0
2010-01-11 08:00:00	SPY	ETF	114.99	115.12	114.95	115.05	428470.0
2010-01-11 08:30:00	SPY	ETF	115.06	115.09	114.9	115.01	1081153.0
2010-01-11 09:00:00	SPY	ETF	115.01	115.08	114.98	115.08	1015463.0
2010-01-11 09:30:00	SPY	ETF	115.08	115.13	114.6	114.63	13701486.0
2010-01-11 10:00:00	SPY	ETF	114.6301	114.74	114.37	114.5883	12989111.0
2010-01-11 10:30:00	SPY	ETF	114.58	114.69	114.48	114.6	5323309.0
2010-01-11 11:00:00	SPY	ETF	114.61	114.64	114.29	114.37	6757535.0
2010-01-11 11:30:00	SPY	ETF	114.37	114.57	114.36	114.55	5821859.0
2010-01-11 12:00:00	SPY	ETF	114.56	114.6	114.4	114.51	3282015.0
2010-01-11 12:30:00	SPY	ETF	114.51	114.53	114.24	114.355	5523466.0
2010-01-11 13:00:00	SPY	ETF	114.36	114.42	114.3	114.4	3466354.0
2010-01-11 13:30:00	SPY	ETF	114.4	114.54	114.38	114.51	3757539.0
2010-01-11 14:00:00	SPY	ETF	114.51	114.59	114.41	114.5	4365864.0
2010-01-11 14:30:00	SPY	ETF	114.5	114.57	114.44	114.54	4881565.0
2010-01-11 15:00:00	SPY	ETF	114.52	114.8	114.235	114.78	8151150.0
2010-01-11 15:30:00	SPY	ETF	114.7881	114.86	114.7	114.73	13425822.0
2010-01-11 16:00:00	SPY	ETF	114.74	114.77	114.41	114.59	2435631.0
2010-01-11 16:30:00	SPY	ETF	114.58	114.64	114.38	114.45	2415992.0
2010-01-11 17:00:00	SPY	ETF	114.45	114.5	114.39	114.48	714380.0
2010-01-11 17:30:00	SPY	ETF	114.48	114.52	114.42	114.52	102715.0
2010-01-11 18:00:00	SPY	ETF	114.51	114.6	114.44	114.57	195965.0
2010-01-11 18:30:00	SPY	ETF	114.58	114.6	114.41	114.42	40910.0
2010-01-11 19:00:00	SPY	ETF	114.4	114.6	114.4	114.59	26805.0
2010-01-11 19:30:00	SPY	ETF	114.59	115.12	114.4	114.57	206819.0
2010-01-11 04:00:00	QQQ	ETF	46.73	46.73	46.73	46.73	1000.0
2010-01-11 04:30:00	QQQ	ETF	46.76	46.76	46.76	46.76	300.0
2010-01-11 05:00:00	QQQ	ETF	46.72	46.73	46.72	46.72	3486.0
2010-01-11 05:30:00	QQQ	ETF	46.77	46.77	46.77	46.77	1200.0
2010-01-11 06:00:00	QQQ	ETF	46.76	46.76	46.67	46.7	20619.0
2010-01-11 06:30:00	QQQ	ETF	46.7	46.7	46.68	46.68	26800.0
2010-01-11 07:00:00	QQQ	ETF	46.68	46.68	46.62	46.65	85465.0
2010-01-11 07:30:00	QQQ	ETF	46.66	46.69	46.61	46.62	114100.0
2010-01-11 08:00:00	QQQ	ETF	46.62	46.69	46.62	46.67	256013.0
2010-01-11 08:30:00	QQQ	ETF	46.65	46.8	46.59	46.61	1641981.0
2010-01-11 09:00:00	QQQ	ETF	46.61	46.62	46.56	46.6	1727096.0
2010-01-11 09:30:00	QQQ	ETF	46.6	46.64	46.32	46.32	16724151.0
2010-01-11 10:00:00	QQQ	ETF	46.33	46.4005	46.12	46.28	18517849.0
2010-01-11 10:30:00	QQQ	ETF	46.2799	46.43	46.22	46.295	3812332.0
2010-01-11 11:00:00	QQQ	ETF	46.2833	46.29	46.13	46.18	7278793.0
2010-01-11 11:30:00	QQQ	ETF	46.18	46.32	46.17	46.32	5380940.0
2010-01-11 12:00:00	QQQ	ETF	46.32	46.36	46.3	46.32	5836514.0
2010-01-11 12:30:00	QQQ	ETF	46.32	46.33	46.17	46.2281	3662610.0

> showing 50 of 8,255 rows — these rows as CSV

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