PREVIEW / etf_30min / 2009-03-23

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-03-23.parquet
  size:    221 KB
  rows:    7,234

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-03-23 04:00:00	SPY	ETF	78.95	78.98	78.83	78.83	42770.0
2009-03-23 04:30:00	SPY	ETF	78.75	78.85	78.75	78.85	600.0
2009-03-23 05:00:00	SPY	ETF	78.98	79.03	78.95	79.02	8930.0
2009-03-23 05:30:00	SPY	ETF	78.87	78.87	78.8	78.87	4400.0
2009-03-23 06:00:00	SPY	ETF	79.0	79.05	78.85	79.05	6130.0
2009-03-23 06:30:00	SPY	ETF	78.99	79.16	78.99	79.04	267202.0
2009-03-23 07:00:00	SPY	ETF	79.0	79.03	78.83	78.98	854610.0
2009-03-23 07:30:00	SPY	ETF	78.98	79.37	78.94	79.35	1158681.0
2009-03-23 08:00:00	SPY	ETF	79.35	79.42	78.63	78.68	4637606.0
2009-03-23 08:30:00	SPY	ETF	78.69	78.73	77.7276	78.49	3551534.0
2009-03-23 09:00:00	SPY	ETF	78.5	78.75	78.25	78.73	2072069.0
2009-03-23 09:30:00	SPY	ETF	78.74	79.11	78.4	78.81	33861840.0
2009-03-23 10:00:00	SPY	ETF	78.81	79.78	78.8001	79.55	42923374.0
2009-03-23 10:30:00	SPY	ETF	79.55	80.0	79.47	79.95	27520783.0
2009-03-23 11:00:00	SPY	ETF	79.95	80.07	79.64	79.72	19971338.0
2009-03-23 11:30:00	SPY	ETF	79.72	80.42	79.69	80.31	23862591.0
2009-03-23 12:00:00	SPY	ETF	80.31	80.4	80.13	80.3	15068593.0
2009-03-23 12:30:00	SPY	ETF	80.31	80.36	80.06	80.07	14452439.0
2009-03-23 13:00:00	SPY	ETF	80.07	80.53	79.77	79.81	22618539.0
2009-03-23 13:30:00	SPY	ETF	79.82	79.93	79.6	79.77	17959100.0
2009-03-23 14:00:00	SPY	ETF	79.769	80.12	79.63	80.0801	16122564.0
2009-03-23 14:30:00	SPY	ETF	80.08	80.96	80.06	80.9	29246047.0
2009-03-23 15:00:00	SPY	ETF	80.91	81.18	80.69	81.16	35158042.0
2009-03-23 15:30:00	SPY	ETF	81.15	82.27	81.04	82.27	67037158.0
2009-03-23 16:00:00	SPY	ETF	82.25	82.42	76.8226	82.14	23155218.0
2009-03-23 16:30:00	SPY	ETF	82.11	82.17	82.02	82.15	5923027.0
2009-03-23 17:00:00	SPY	ETF	82.16	82.25	82.1	82.2	3795573.0
2009-03-23 17:30:00	SPY	ETF	82.16	82.2	82.11	82.16	4058300.0
2009-03-23 18:00:00	SPY	ETF	82.17	82.22	82.11	82.13	40766.0
2009-03-23 18:30:00	SPY	ETF	82.12	82.13	81.99	82.02	126980.0
2009-03-23 19:00:00	SPY	ETF	82.02	82.02	81.95	81.96	77145.0
2009-03-23 19:30:00	SPY	ETF	81.95	82.0	81.91	81.99	98308.0
2009-03-23 04:00:00	QQQ	ETF	29.97	29.97	29.97	29.97	1100.0
2009-03-23 04:30:00	QQQ	ETF	29.94	29.94	29.94	29.94	100.0
2009-03-23 05:00:00	QQQ	ETF	30.0	30.0	30.0	30.0	200.0
2009-03-23 05:30:00	QQQ	ETF	29.96	30.0	29.96	30.0	4300.0
2009-03-23 06:00:00	QQQ	ETF	30.0	30.01	29.97	30.0	5000.0
2009-03-23 06:30:00	QQQ	ETF	30.04	30.04	30.0	30.0	30000.0
2009-03-23 07:00:00	QQQ	ETF	29.97	29.98	29.9	29.98	1042819.0
2009-03-23 07:30:00	QQQ	ETF	29.99	30.1	29.97	30.05	474577.0
2009-03-23 08:00:00	QQQ	ETF	30.05	30.12	29.79	29.79	3833091.0
2009-03-23 08:30:00	QQQ	ETF	29.79	29.95	29.5048	29.8	546060.0
2009-03-23 09:00:00	QQQ	ETF	29.82	29.89	29.73	29.86	690194.0
2009-03-23 09:30:00	QQQ	ETF	29.86	29.92	29.61	29.79	15582681.0
2009-03-23 10:00:00	QQQ	ETF	29.8	30.12	29.8	30.04	12861540.0
2009-03-23 10:30:00	QQQ	ETF	30.04	30.2	30.02	30.1599	11136765.0
2009-03-23 11:00:00	QQQ	ETF	30.15	30.22	30.11	30.13	5591318.0
2009-03-23 11:30:00	QQQ	ETF	30.13	30.42	30.13	30.38	10147305.0
2009-03-23 12:00:00	QQQ	ETF	30.39	30.43	30.29	30.35	6781406.0
2009-03-23 12:30:00	QQQ	ETF	30.35	30.37	30.27	30.2701	3981219.0

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

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