PREVIEW / etf_30min / 2010-01-08

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-01-08.parquet
  size:    237 KB
  rows:    8,026

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-08 04:30:00	SPY	ETF	114.25	114.25	114.25	114.25	100.0
2010-01-08 05:00:00	SPY	ETF	114.26	114.26	114.26	114.26	200.0
2010-01-08 05:30:00	SPY	ETF	114.26	114.26	114.26	114.26	3300.0
2010-01-08 06:00:00	SPY	ETF	114.22	114.27	114.22	114.27	3300.0
2010-01-08 06:30:00	SPY	ETF	114.27	114.33	114.27	114.33	40300.0
2010-01-08 07:00:00	SPY	ETF	114.28	114.28	114.2	114.2	900.0
2010-01-08 07:30:00	SPY	ETF	114.23	114.25	114.12	114.17	223600.0
2010-01-08 08:00:00	SPY	ETF	114.18	114.38	113.97	114.15	1095026.0
2010-01-08 08:30:00	SPY	ETF	114.31	114.32	113.54	113.84	6748699.0
2010-01-08 09:00:00	SPY	ETF	113.85	114.24	113.7	113.89	2044304.0
2010-01-08 09:30:00	SPY	ETF	113.89	114.09	113.66	114.06	16257658.0
2010-01-08 10:00:00	SPY	ETF	114.07	114.2	113.97	114.115	12360765.0
2010-01-08 10:30:00	SPY	ETF	114.11	114.17	113.92	114.15	8781246.0
2010-01-08 11:00:00	SPY	ETF	114.125	114.2	114.01	114.13	6276303.0
2010-01-08 11:30:00	SPY	ETF	114.13	114.15	113.96	114.11	6452669.0
2010-01-08 12:00:00	SPY	ETF	114.11	114.19	114.05	114.15	3833339.0
2010-01-08 12:30:00	SPY	ETF	114.14	114.2	114.06	114.06	3305026.0
2010-01-08 13:00:00	SPY	ETF	114.07	114.25	114.06	114.16	3573304.0
2010-01-08 13:30:00	SPY	ETF	114.15	114.31	114.06	114.08	6941893.0
2010-01-08 14:00:00	SPY	ETF	114.08	114.13	114.02	114.12	4739565.0
2010-01-08 14:30:00	SPY	ETF	114.12	114.17	114.07	114.11	5109102.0
2010-01-08 15:00:00	SPY	ETF	114.11	114.23	114.06	114.21	6163693.0
2010-01-08 15:30:00	SPY	ETF	114.2	114.61	114.17	114.57	14189619.0
2010-01-08 16:00:00	SPY	ETF	114.56	114.66	113.73	114.6	9827135.0
2010-01-08 16:30:00	SPY	ETF	114.63	114.64	114.13	114.63	7006552.0
2010-01-08 17:00:00	SPY	ETF	114.66	114.73	114.64	114.68	85580.0
2010-01-08 17:30:00	SPY	ETF	114.68	114.76	114.65	114.7	90683.0
2010-01-08 18:00:00	SPY	ETF	114.7	114.72	114.68	114.68	4300.0
2010-01-08 18:30:00	SPY	ETF	114.68	114.68	114.65	114.68	11800.0
2010-01-08 19:00:00	SPY	ETF	114.7	114.71	114.6	114.63	18750.0
2010-01-08 19:30:00	SPY	ETF	114.68	114.71	114.68	114.7	10003.0
2010-01-08 06:30:00	QQQ	ETF	46.24	46.28	46.24	46.25	32300.0
2010-01-08 07:00:00	QQQ	ETF	46.26	46.26	46.22	46.22	42820.0
2010-01-08 07:30:00	QQQ	ETF	46.22	46.24	46.21	46.22	142900.0
2010-01-08 08:00:00	QQQ	ETF	46.22	46.32	46.16	46.16	918340.0
2010-01-08 08:30:00	QQQ	ETF	46.18	46.34	45.89	46.04	4518227.0
2010-01-08 09:00:00	QQQ	ETF	46.04	46.08	45.95	46.04	807820.0
2010-01-08 09:30:00	QQQ	ETF	46.04	46.18	45.93	46.15	16038339.0
2010-01-08 10:00:00	QQQ	ETF	46.15	46.41	46.15	46.34	16552394.0
2010-01-08 10:30:00	QQQ	ETF	46.35	46.37	46.18	46.32	6475057.0
2010-01-08 11:00:00	QQQ	ETF	46.31	46.42	46.25	46.39	4158685.0
2010-01-08 11:30:00	QQQ	ETF	46.39	46.41	46.33	46.39	3165792.0
2010-01-08 12:00:00	QQQ	ETF	46.39	46.41	46.33	46.3776	3149029.0
2010-01-08 12:30:00	QQQ	ETF	46.38	46.42	46.35	46.39	3166251.0
2010-01-08 13:00:00	QQQ	ETF	46.39	46.47	46.37	46.4396	2736689.0
2010-01-08 13:30:00	QQQ	ETF	46.44	46.53	46.43	46.44	6433574.0
2010-01-08 14:00:00	QQQ	ETF	46.44	46.48	46.42	46.4499	2382844.0
2010-01-08 14:30:00	QQQ	ETF	46.45	46.47	46.41	46.44	3019342.0
2010-01-08 15:00:00	QQQ	ETF	46.451	46.5	46.35	46.495	2953778.0
2010-01-08 15:30:00	QQQ	ETF	46.5	46.55	46.47	46.55	5986492.0

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

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