PREVIEW / etf_30min / 2008-06-09

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-06-09.parquet
  size:    168 KB
  rows:    5,703

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
2008-06-09 04:30:00	SPY	ETF	136.81	137.0	136.81	137.0	60600.0
2008-06-09 05:00:00	SPY	ETF	137.0	137.0	136.77	136.78	91500.0
2008-06-09 05:30:00	SPY	ETF	136.74	136.89	136.71	136.89	23900.0
2008-06-09 06:00:00	SPY	ETF	136.85	136.85	136.58	136.65	113700.0
2008-06-09 06:30:00	SPY	ETF	136.72	136.99	136.7	136.82	158500.0
2008-06-09 07:00:00	SPY	ETF	136.84	136.97	136.28	136.74	784921.0
2008-06-09 07:30:00	SPY	ETF	136.69	136.91	136.6	136.6	603597.0
2008-06-09 08:00:00	SPY	ETF	136.62	137.02	136.4	136.74	1069593.0
2008-06-09 08:30:00	SPY	ETF	136.74	137.03	136.68	136.89	601029.0
2008-06-09 09:00:00	SPY	ETF	136.92	137.11	136.84	136.84	1440602.0
2008-06-09 09:30:00	SPY	ETF	136.86	137.04	136.38	136.99	25193329.0
2008-06-09 10:00:00	SPY	ETF	136.99	137.5	136.8	137.16	30537974.0
2008-06-09 10:30:00	SPY	ETF	137.15	137.28	136.81	136.87	11925360.0
2008-06-09 11:00:00	SPY	ETF	136.87	137.24	136.79	137.18	8485972.0
2008-06-09 11:30:00	SPY	ETF	137.18	137.41	136.95	137.03	8199083.0
2008-06-09 12:00:00	SPY	ETF	137.03	137.1	136.79	137.0	7309222.0
2008-06-09 12:30:00	SPY	ETF	137.0	137.22	136.97	137.15	5178248.0
2008-06-09 13:00:00	SPY	ETF	137.14	137.15	136.11	136.39	16384522.0
2008-06-09 13:30:00	SPY	ETF	136.39	136.51	135.82	136.02	14858957.0
2008-06-09 14:00:00	SPY	ETF	136.01	136.12	135.41	135.97	27489967.0
2008-06-09 14:30:00	SPY	ETF	135.97	136.38	135.83	135.87	22173749.0
2008-06-09 15:00:00	SPY	ETF	135.87	136.39	135.555	135.86	17656279.0
2008-06-09 15:30:00	SPY	ETF	135.86	136.75	135.86	136.63	21404030.0
2008-06-09 16:00:00	SPY	ETF	136.65	136.7624	135.0	136.6	3236346.0
2008-06-09 16:30:00	SPY	ETF	136.59	136.75	136.55	136.67	281838.0
2008-06-09 17:00:00	SPY	ETF	136.66	136.71	136.64	136.66	141296.0
2008-06-09 17:30:00	SPY	ETF	136.65	136.68	136.56	136.68	17932.0
2008-06-09 18:00:00	SPY	ETF	136.66	136.69	136.53	136.53	33156.0
2008-06-09 18:30:00	SPY	ETF	136.52	136.53	136.51	136.51	7759.0
2008-06-09 19:00:00	SPY	ETF	136.53	136.53	136.53	136.53	250.0
2008-06-09 19:30:00	SPY	ETF	136.56	136.63	136.56	136.63	4149.0
2008-06-09 04:30:00	QQQ	ETF	49.15	49.15	49.15	49.15	800.0
2008-06-09 06:00:00	QQQ	ETF	49.08	49.08	49.03	49.03	200.0
2008-06-09 06:30:00	QQQ	ETF	49.08	49.08	49.08	49.08	100.0
2008-06-09 07:00:00	QQQ	ETF	49.13	49.14	48.92	49.09	51900.0
2008-06-09 07:30:00	QQQ	ETF	49.08	49.17	49.04	49.04	281100.0
2008-06-09 08:00:00	QQQ	ETF	49.04	49.2	49.03	49.09	735223.0
2008-06-09 08:30:00	QQQ	ETF	49.07	49.16	49.06	49.11	399214.0
2008-06-09 09:00:00	QQQ	ETF	49.12	49.2	49.11	49.12	390213.0
2008-06-09 09:30:00	QQQ	ETF	49.11	49.19	48.41	48.71	21678583.0
2008-06-09 10:00:00	QQQ	ETF	48.72	49.01	48.6	48.74	22722191.0
2008-06-09 10:30:00	QQQ	ETF	48.73	48.79	48.46	48.4899	13959589.0
2008-06-09 11:00:00	QQQ	ETF	48.49	48.69	48.48	48.69	9200600.0
2008-06-09 11:30:00	QQQ	ETF	48.69	48.75	48.6	48.65	6935606.0
2008-06-09 12:00:00	QQQ	ETF	48.64	48.65	48.49	48.59	4442957.0
2008-06-09 12:30:00	QQQ	ETF	48.5901	48.74	48.57	48.71	4919721.0
2008-06-09 13:00:00	QQQ	ETF	48.71	48.72	48.26	48.37	14252826.0
2008-06-09 13:30:00	QQQ	ETF	48.372	48.46	48.0	48.1401	14990275.0
2008-06-09 14:00:00	QQQ	ETF	48.14	48.28	47.95	48.2512	18177215.0
2008-06-09 14:30:00	QQQ	ETF	48.25	48.55	48.12	48.18	22395697.0

> showing 50 of 5,703 rows — these rows as CSV

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