PREVIEW / etf_30min / 2009-02-26

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-02-26.parquet
  size:    202 KB
  rows:    6,653

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-02-26 04:00:00	SPY	ETF	77.54	77.68	77.54	77.68	1500.0
2009-02-26 04:30:00	SPY	ETF	77.4	77.51	77.36	77.36	400.0
2009-02-26 05:00:00	SPY	ETF	77.3	77.3	77.3	77.3	100.0
2009-02-26 05:30:00	SPY	ETF	77.01	77.01	76.94	76.94	200.0
2009-02-26 06:00:00	SPY	ETF	77.14	77.4	77.07	77.4	344800.0
2009-02-26 06:30:00	SPY	ETF	77.45	77.82	77.45	77.51	330310.0
2009-02-26 07:00:00	SPY	ETF	77.49	77.85	77.42	77.72	332141.0
2009-02-26 07:30:00	SPY	ETF	77.71	78.22	77.61	78.09	885082.0
2009-02-26 08:00:00	SPY	ETF	78.23	78.23	77.3	77.9	2922852.0
2009-02-26 08:30:00	SPY	ETF	77.8	77.87	77.42	77.83	2922190.0
2009-02-26 09:00:00	SPY	ETF	77.82	78.01	77.72	77.83	1936797.0
2009-02-26 09:30:00	SPY	ETF	77.82	78.03	77.31	77.78	32193052.0
2009-02-26 10:00:00	SPY	ETF	77.78	78.16	77.48	78.08	31187551.0
2009-02-26 10:30:00	SPY	ETF	78.07	78.375	77.77	78.22	25755455.0
2009-02-26 11:00:00	SPY	ETF	78.22	78.28	77.61	77.68	22085687.0
2009-02-26 11:30:00	SPY	ETF	77.69	77.76	77.25	77.54	14805558.0
2009-02-26 12:00:00	SPY	ETF	77.54	77.72	76.92	77.05	15991109.0
2009-02-26 12:30:00	SPY	ETF	77.05	77.65	76.95	77.15	15978749.0
2009-02-26 13:00:00	SPY	ETF	77.15	77.2	76.53	76.93	21229239.0
2009-02-26 13:30:00	SPY	ETF	76.93	77.3	76.77	77.13	16362448.0
2009-02-26 14:00:00	SPY	ETF	77.13	77.24	76.69	77.09	15694980.0
2009-02-26 14:30:00	SPY	ETF	77.09	77.1	76.01	76.18	29592227.0
2009-02-26 15:00:00	SPY	ETF	76.19	79.6667	75.53	75.79	41102533.0
2009-02-26 15:30:00	SPY	ETF	75.79	77.2	75.59	75.67	50835421.0
2009-02-26 16:00:00	SPY	ETF	75.67	76.8905	75.49	75.72	14774285.0
2009-02-26 16:30:00	SPY	ETF	75.71	75.81	75.62	75.71	327141.0
2009-02-26 17:00:00	SPY	ETF	75.7	75.76	75.6	75.61	251763.0
2009-02-26 17:30:00	SPY	ETF	75.61	75.63	75.5	75.6	162973.0
2009-02-26 18:00:00	SPY	ETF	75.6	75.66	75.58	75.6	81956.0
2009-02-26 18:30:00	SPY	ETF	75.6	75.73	75.57	75.71	74264.0
2009-02-26 19:00:00	SPY	ETF	75.73	75.76	75.5	75.6	44601.0
2009-02-26 19:30:00	SPY	ETF	75.57	75.74	75.55	75.74	44214.0
2009-02-26 04:00:00	QQQ	ETF	28.78	28.84	28.78	28.84	1700.0
2009-02-26 04:30:00	QQQ	ETF	28.7	28.7	28.67	28.67	300.0
2009-02-26 05:00:00	QQQ	ETF	28.71	28.71	28.71	28.71	100.0
2009-02-26 05:30:00	QQQ	ETF	28.66	28.66	28.6	28.6	1100.0
2009-02-26 06:00:00	QQQ	ETF	28.63	28.63	28.63	28.63	300.0
2009-02-26 06:30:00	QQQ	ETF	28.73	28.85	28.73	28.84	19800.0
2009-02-26 07:00:00	QQQ	ETF	28.7	28.81	28.7	28.76	13600.0
2009-02-26 07:30:00	QQQ	ETF	28.76	28.9	28.76	28.86	35100.0
2009-02-26 08:00:00	QQQ	ETF	28.85	28.85	28.74	28.79	303294.0
2009-02-26 08:30:00	QQQ	ETF	28.76	28.82	28.66	28.79	621348.0
2009-02-26 09:00:00	QQQ	ETF	28.77	28.83	28.75	28.78	555882.0
2009-02-26 09:30:00	QQQ	ETF	28.78	28.81	28.42	28.61	22574984.0
2009-02-26 10:00:00	QQQ	ETF	28.6	28.8	28.54	28.76	13296926.0
2009-02-26 10:30:00	QQQ	ETF	28.76	28.95	28.65	28.88	11277990.0
2009-02-26 11:00:00	QQQ	ETF	28.89	28.91	28.61	28.62	10972775.0
2009-02-26 11:30:00	QQQ	ETF	28.62	28.66	28.42	28.61	8898341.0
2009-02-26 12:00:00	QQQ	ETF	28.61	28.67	28.37	28.44	8573150.0
2009-02-26 12:30:00	QQQ	ETF	28.43	28.52	28.36	28.4	6986306.0

> showing 50 of 6,653 rows — these rows as CSV

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