PREVIEW / etf_30min / 2010-03-16

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-16.parquet
  size:    246 KB
  rows:    8,179

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-03-16 04:00:00	SPY	ETF	115.48	115.48	115.48	115.48	665.0
2010-03-16 04:30:00	SPY	ETF	115.55	115.55	115.55	115.55	100.0
2010-03-16 05:00:00	SPY	ETF	115.64	115.68	115.64	115.68	400.0
2010-03-16 05:30:00	SPY	ETF	115.74	115.74	115.68	115.68	800.0
2010-03-16 06:00:00	SPY	ETF	115.74	115.74	115.7	115.7	3100.0
2010-03-16 06:30:00	SPY	ETF	115.65	115.71	115.65	115.71	3525.0
2010-03-16 07:00:00	SPY	ETF	115.76	115.79	115.72	115.78	54425.0
2010-03-16 07:30:00	SPY	ETF	115.8	115.8	115.69	115.7	130770.0
2010-03-16 08:00:00	SPY	ETF	115.71	115.77	115.65	115.65	677075.0
2010-03-16 08:30:00	SPY	ETF	115.66	115.83	115.64	115.73	918524.0
2010-03-16 09:00:00	SPY	ETF	115.72	115.88	115.72	115.81	1419883.0
2010-03-16 09:30:00	SPY	ETF	115.81	115.84	115.49	115.72	16146868.0
2010-03-16 10:00:00	SPY	ETF	115.71	115.82	115.58	115.8	9841604.0
2010-03-16 10:30:00	SPY	ETF	115.79	116.12	115.74	116.07	13576338.0
2010-03-16 11:00:00	SPY	ETF	116.08	116.23	116.0	116.13	12614565.0
2010-03-16 11:30:00	SPY	ETF	116.13	116.19	116.05	116.11	9101552.0
2010-03-16 12:00:00	SPY	ETF	116.12	116.15	116.01	116.07	6320678.0
2010-03-16 12:30:00	SPY	ETF	116.0699	116.11	115.96	116.02	4912724.0
2010-03-16 13:00:00	SPY	ETF	116.01	116.05	115.95	115.99	3310882.0
2010-03-16 13:30:00	SPY	ETF	115.98	116.0	115.87	115.97	4048320.0
2010-03-16 14:00:00	SPY	ETF	115.96	116.34	115.82	116.23	22439912.0
2010-03-16 14:30:00	SPY	ETF	116.23	116.23	115.8	116.17	18058052.0
2010-03-16 15:00:00	SPY	ETF	116.18	116.37	116.09	116.3001	15010297.0
2010-03-16 15:30:00	SPY	ETF	116.3	116.52	116.23	116.41	22540064.0
2010-03-16 16:00:00	SPY	ETF	116.41	116.44	115.5231	116.39	4762345.0
2010-03-16 16:30:00	SPY	ETF	116.4	116.42	116.36	116.39	486093.0
2010-03-16 17:00:00	SPY	ETF	116.4	116.45	116.38	116.41	64019.0
2010-03-16 17:30:00	SPY	ETF	116.4	116.41	116.35	116.4	87944.0
2010-03-16 18:00:00	SPY	ETF	116.41	116.42	116.41	116.41	15213.0
2010-03-16 18:30:00	SPY	ETF	116.4	116.42	116.39	116.41	13405.0
2010-03-16 19:00:00	SPY	ETF	116.41	116.42	116.4	116.4	14700.0
2010-03-16 19:30:00	SPY	ETF	116.42	116.44	116.38	116.43	74751.0
2010-03-16 05:30:00	QQQ	ETF	47.31	47.31	47.31	47.31	2400.0
2010-03-16 07:00:00	QQQ	ETF	47.35	47.35	47.34	47.35	1459.0
2010-03-16 07:30:00	QQQ	ETF	47.33	47.34	47.33	47.33	14087.0
2010-03-16 08:00:00	QQQ	ETF	47.33	47.35	47.3	47.31	171737.0
2010-03-16 08:30:00	QQQ	ETF	47.31	47.39	47.31	47.32	73808.0
2010-03-16 09:00:00	QQQ	ETF	47.32	47.4	47.32	47.39	225725.0
2010-03-16 09:30:00	QQQ	ETF	47.39	47.4	47.24	47.33	6932478.0
2010-03-16 10:00:00	QQQ	ETF	47.32	47.37	47.23	47.34	6704170.0
2010-03-16 10:30:00	QQQ	ETF	47.33	47.51	47.3	47.5	7027937.0
2010-03-16 11:00:00	QQQ	ETF	47.4937	47.54	47.2599	47.51	5961582.0
2010-03-16 11:30:00	QQQ	ETF	47.51	47.53	47.45	47.49	2277954.0
2010-03-16 12:00:00	QQQ	ETF	47.49	47.52	47.46	47.4976	1695932.0
2010-03-16 12:30:00	QQQ	ETF	47.49	47.51	47.45	47.46	1220303.0
2010-03-16 13:00:00	QQQ	ETF	47.455	47.48	47.44	47.4401	781567.0
2010-03-16 13:30:00	QQQ	ETF	47.45	47.46	47.41	47.44	1467730.0
2010-03-16 14:00:00	QQQ	ETF	47.435	47.61	47.38	47.54	9722661.0
2010-03-16 14:30:00	QQQ	ETF	47.54	47.55	47.32	47.475	8368650.0
2010-03-16 15:00:00	QQQ	ETF	47.47	47.54	47.42	47.5062	4927377.0

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

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