PREVIEW / etf_30min / 2009-05-19

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-05-19.parquet
  size:    219 KB
  rows:    7,288

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
2009-05-19 04:00:00	SPY	ETF	91.57	91.63	91.57	91.63	3100.0
2009-05-19 04:30:00	SPY	ETF	91.7	91.73	91.65	91.71	3100.0
2009-05-19 05:00:00	SPY	ETF	91.71	91.78	91.45	91.55	2600.0
2009-05-19 05:30:00	SPY	ETF	91.67	91.88	91.67	91.73	6600.0
2009-05-19 06:00:00	SPY	ETF	91.71	91.97	91.67	91.97	22710.0
2009-05-19 06:30:00	SPY	ETF	91.99	92.0	91.89	91.89	68200.0
2009-05-19 07:00:00	SPY	ETF	91.85	91.88	91.7	91.73	547837.0
2009-05-19 07:30:00	SPY	ETF	91.73	91.73	91.57	91.61	331343.0
2009-05-19 08:00:00	SPY	ETF	91.62	92.05	91.46	91.68	2319190.0
2009-05-19 08:30:00	SPY	ETF	91.67	91.7	91.08	91.16	4741238.0
2009-05-19 09:00:00	SPY	ETF	91.16	91.23	91.04	91.18	2151906.0
2009-05-19 09:30:00	SPY	ETF	91.18	91.46	90.87	90.89	24569389.0
2009-05-19 10:00:00	SPY	ETF	90.89	91.62	90.81	91.61	21862568.0
2009-05-19 10:30:00	SPY	ETF	91.61	91.89	91.5	91.58	18406380.0
2009-05-19 11:00:00	SPY	ETF	91.57	91.7398	91.26	91.5	10879306.0
2009-05-19 11:30:00	SPY	ETF	91.5	91.74	91.49	91.59	9342857.0
2009-05-19 12:00:00	SPY	ETF	91.59	91.78	91.5	91.73	6623696.0
2009-05-19 12:30:00	SPY	ETF	91.74	91.74	91.33	91.34	9149110.0
2009-05-19 13:00:00	SPY	ETF	91.33	91.85	91.32	91.77	9650275.0
2009-05-19 13:30:00	SPY	ETF	91.78	91.86	91.5	91.58	10859941.0
2009-05-19 14:00:00	SPY	ETF	91.58	91.77	91.35	91.73	10588796.0
2009-05-19 14:30:00	SPY	ETF	91.73	91.97	91.7	91.78	12529523.0
2009-05-19 15:00:00	SPY	ETF	91.78	91.97	91.7	91.82	10343169.0
2009-05-19 15:30:00	SPY	ETF	91.83	91.85	91.03	91.11	30566708.0
2009-05-19 16:00:00	SPY	ETF	91.08	91.4786	91.0	91.02	8637193.0
2009-05-19 16:30:00	SPY	ETF	91.02	91.06	90.88	90.88	550711.0
2009-05-19 17:00:00	SPY	ETF	90.86	90.9	90.73	90.8	264747.0
2009-05-19 17:30:00	SPY	ETF	90.84	90.94	90.8	90.86	107826.0
2009-05-19 18:00:00	SPY	ETF	90.85	91.0	90.83	91.0	114171.0
2009-05-19 18:30:00	SPY	ETF	91.0	91.04	90.91	90.95	120300.0
2009-05-19 19:00:00	SPY	ETF	90.93	91.05	90.93	91.05	20600.0
2009-05-19 19:30:00	SPY	ETF	91.0	91.1	90.98	91.08	66409.0
2009-05-19 06:00:00	QQQ	ETF	34.36	34.41	34.32	34.41	5100.0
2009-05-19 06:30:00	QQQ	ETF	34.43	34.43	34.38	34.38	76275.0
2009-05-19 07:00:00	QQQ	ETF	34.38	34.38	34.29	34.33	620187.0
2009-05-19 07:30:00	QQQ	ETF	34.32	34.32	34.22	34.24	410624.0
2009-05-19 08:00:00	QQQ	ETF	34.24	34.36	34.12	34.21	3180485.0
2009-05-19 08:30:00	QQQ	ETF	34.21	34.21	34.06	34.09	1555638.0
2009-05-19 09:00:00	QQQ	ETF	34.09	34.15	34.03	34.13	892616.0
2009-05-19 09:30:00	QQQ	ETF	34.13	34.28	33.95	34.08	20459621.0
2009-05-19 10:00:00	QQQ	ETF	34.07	34.35	34.03	34.33	9683649.0
2009-05-19 10:30:00	QQQ	ETF	34.33	34.47	34.32	34.34	10392539.0
2009-05-19 11:00:00	QQQ	ETF	34.34	34.39	34.21	34.29	6876750.0
2009-05-19 11:30:00	QQQ	ETF	34.29	34.38	34.2899	34.34	4503348.0
2009-05-19 12:00:00	QQQ	ETF	34.35	34.47	34.31	34.4601	3052458.0
2009-05-19 12:30:00	QQQ	ETF	34.46	34.47	34.35	34.36	3395088.0
2009-05-19 13:00:00	QQQ	ETF	34.36	34.63	34.35	34.6101	8398802.0
2009-05-19 13:30:00	QQQ	ETF	34.61	34.66	34.51	34.57	6350954.0
2009-05-19 14:00:00	QQQ	ETF	34.5699	34.65	34.49	34.64	5172276.0
2009-05-19 14:30:00	QQQ	ETF	34.63	34.74	34.59	34.6412	7345215.0

> showing 50 of 7,288 rows — these rows as CSV

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