PREVIEW / etf_30min / 2008-05-13

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-05-13.parquet
  size:    158 KB
  rows:    5,545

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-05-13 05:30:00	SPY	ETF	140.1	140.1	140.0	140.03	90000.0
2008-05-13 06:00:00	SPY	ETF	140.12	140.12	139.85	140.0	292800.0
2008-05-13 06:30:00	SPY	ETF	140.0	140.18	140.0	140.11	195600.0
2008-05-13 07:00:00	SPY	ETF	140.12	140.16	139.99	139.99	244643.0
2008-05-13 07:30:00	SPY	ETF	139.99	140.1	139.95	140.08	658293.0
2008-05-13 08:00:00	SPY	ETF	140.09	140.35	140.05	140.22	1977456.0
2008-05-13 08:30:00	SPY	ETF	140.25	141.11	140.15	140.93	7215048.0
2008-05-13 09:00:00	SPY	ETF	140.96	140.96	140.46	140.81	1015579.0
2008-05-13 09:30:00	SPY	ETF	140.8	140.89	140.17	140.23	21871425.0
2008-05-13 10:00:00	SPY	ETF	140.24	140.6	140.01	140.24	16717444.0
2008-05-13 10:30:00	SPY	ETF	140.25	140.4	139.81	139.92	9848876.0
2008-05-13 11:00:00	SPY	ETF	139.92	140.16	139.73	139.94	10508223.0
2008-05-13 11:30:00	SPY	ETF	139.93	140.18	139.78	140.13	11299631.0
2008-05-13 12:00:00	SPY	ETF	140.13	140.41	140.0	140.29	11370529.0
2008-05-13 12:30:00	SPY	ETF	140.3	140.43	140.08	140.16	6997823.0
2008-05-13 13:00:00	SPY	ETF	140.15	140.27	140.01	140.21	7794790.0
2008-05-13 13:30:00	SPY	ETF	140.2	140.47	140.15	140.3	6973857.0
2008-05-13 14:00:00	SPY	ETF	140.29	140.51	140.25	140.34	5855146.0
2008-05-13 14:30:00	SPY	ETF	140.33	140.65	140.29	140.6	6568763.0
2008-05-13 15:00:00	SPY	ETF	140.6	140.78	140.27	140.42	14608401.0
2008-05-13 15:30:00	SPY	ETF	140.41	140.51	140.23	140.4	10667009.0
2008-05-13 16:00:00	SPY	ETF	140.44	140.56	139.72	140.48	4551825.0
2008-05-13 16:30:00	SPY	ETF	140.44	140.48	140.3	140.37	305889.0
2008-05-13 17:00:00	SPY	ETF	140.37	140.44	139.7711	140.43	77897.0
2008-05-13 17:30:00	SPY	ETF	140.44	140.48	140.44	140.48	4450.0
2008-05-13 18:00:00	SPY	ETF	140.43	140.47	140.42	140.43	10900.0
2008-05-13 18:30:00	SPY	ETF	140.43	140.43	140.39	140.39	523.0
2008-05-13 19:00:00	SPY	ETF	140.4	140.4	140.37	140.37	3423.0
2008-05-13 19:30:00	SPY	ETF	140.38	140.43	140.38	140.43	4900.0
2008-05-13 05:30:00	QQQ	ETF	48.98	48.98	48.98	48.98	2000.0
2008-05-13 06:00:00	QQQ	ETF	48.96	48.96	48.95	48.96	2100.0
2008-05-13 06:30:00	QQQ	ETF	48.93	48.94	48.93	48.94	5100.0
2008-05-13 07:00:00	QQQ	ETF	49.01	49.01	48.98	48.98	16500.0
2008-05-13 07:30:00	QQQ	ETF	48.97	48.99	48.89	48.96	156978.0
2008-05-13 08:00:00	QQQ	ETF	48.95	49.01	48.95	48.98	248148.0
2008-05-13 08:30:00	QQQ	ETF	48.99	49.2	48.97	49.17	1351567.0
2008-05-13 09:00:00	QQQ	ETF	49.18	49.2	49.11	49.12	516107.0
2008-05-13 09:30:00	QQQ	ETF	49.13	49.14	48.94	48.9901	11535113.0
2008-05-13 10:00:00	QQQ	ETF	49.0	49.15	48.92	49.099	9612127.0
2008-05-13 10:30:00	QQQ	ETF	49.1	49.19	48.83	48.84	7965728.0
2008-05-13 11:00:00	QQQ	ETF	48.845	48.87	48.76	48.82	5301938.0
2008-05-13 11:30:00	QQQ	ETF	48.823	48.93	48.77	48.89	3767107.0
2008-05-13 12:00:00	QQQ	ETF	48.9	49.06	48.89	49.01	3184047.0
2008-05-13 12:30:00	QQQ	ETF	49.01	49.07	48.93	48.95	3594419.0
2008-05-13 13:00:00	QQQ	ETF	48.95	49.04	48.9	48.99	3667991.0
2008-05-13 13:30:00	QQQ	ETF	49.0	49.1	48.98	49.04	3888453.0
2008-05-13 14:00:00	QQQ	ETF	49.04	49.1575	49.03	49.075	3824577.0
2008-05-13 14:30:00	QQQ	ETF	49.089	49.27	49.06	49.2425	4821640.0
2008-05-13 15:00:00	QQQ	ETF	49.25	49.33	49.16	49.2299	7035918.0
2008-05-13 15:30:00	QQQ	ETF	49.2299	49.27	49.17	49.2301	7962875.0

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

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