PREVIEW / etf_30min / 2008-07-21

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-21.parquet
  size:    175 KB
  rows:    6,060

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-07-21 04:00:00	SPY	ETF	125.68	125.84	125.68	125.84	2500.0
2008-07-21 04:30:00	SPY	ETF	125.81	125.81	125.81	125.81	800.0
2008-07-21 05:00:00	SPY	ETF	125.78	125.93	125.78	125.93	600.0
2008-07-21 06:00:00	SPY	ETF	126.23	126.5	126.23	126.5	16600.0
2008-07-21 06:30:00	SPY	ETF	126.46	126.47	126.3	126.42	69900.0
2008-07-21 07:00:00	SPY	ETF	126.39	126.87	126.38	126.65	1923415.0
2008-07-21 07:30:00	SPY	ETF	126.63	126.73	126.35	126.43	1225119.0
2008-07-21 08:00:00	SPY	ETF	126.42	126.76	126.0	126.61	2041328.0
2008-07-21 08:30:00	SPY	ETF	126.62	126.72	126.54	126.7	1469005.0
2008-07-21 09:00:00	SPY	ETF	126.71	126.74	126.48	126.51	1705134.0
2008-07-21 09:30:00	SPY	ETF	126.51	126.75	126.37	126.61	21551620.0
2008-07-21 10:00:00	SPY	ETF	126.61	126.8	126.22	126.27	19827103.0
2008-07-21 10:30:00	SPY	ETF	126.27	126.5	126.1	126.3	16249333.0
2008-07-21 11:00:00	SPY	ETF	126.3	126.47	126.09	126.34	12073371.0
2008-07-21 11:30:00	SPY	ETF	126.34	126.38	125.69	125.7025	13251692.0
2008-07-21 12:00:00	SPY	ETF	125.71	126.03	125.62	125.93	11793961.0
2008-07-21 12:30:00	SPY	ETF	125.93	126.27	125.92	125.99	11383537.0
2008-07-21 13:00:00	SPY	ETF	125.99	126.28	125.97	126.15	9181525.0
2008-07-21 13:30:00	SPY	ETF	126.15	126.38	126.03	126.07	8146854.0
2008-07-21 14:00:00	SPY	ETF	126.09	126.2	125.81	125.89	15338089.0
2008-07-21 14:30:00	SPY	ETF	125.88	125.97	125.7	125.78	15211542.0
2008-07-21 15:00:00	SPY	ETF	125.78	126.0679	125.54	125.89	14049600.0
2008-07-21 15:30:00	SPY	ETF	125.89	126.03	125.71	126.0	17417179.0
2008-07-21 16:00:00	SPY	ETF	126.03	126.74	125.5	125.7	9472885.0
2008-07-21 16:30:00	SPY	ETF	125.7	125.8	124.98	125.0	12921963.0
2008-07-21 17:00:00	SPY	ETF	125.0	125.07	124.92	124.94	407413.0
2008-07-21 17:30:00	SPY	ETF	124.94	124.95	124.39	124.73	416511.0
2008-07-21 18:00:00	SPY	ETF	124.75	124.93	124.74	124.9	299703.0
2008-07-21 18:30:00	SPY	ETF	124.89	124.94	124.89	124.89	22066.0
2008-07-21 19:00:00	SPY	ETF	124.89	124.95	124.85	124.87	20201.0
2008-07-21 19:30:00	SPY	ETF	124.88	125.0	124.88	125.0	24022.0
2008-07-21 04:00:00	QQQ	ETF	44.73	44.73	44.73	44.73	100.0
2008-07-21 04:30:00	QQQ	ETF	44.8	44.8	44.8	44.8	1000.0
2008-07-21 05:00:00	QQQ	ETF	44.86	44.86	44.83	44.86	2500.0
2008-07-21 05:30:00	QQQ	ETF	44.93	45.03	44.93	45.03	2600.0
2008-07-21 06:00:00	QQQ	ETF	45.02	45.1	45.02	45.08	2100.0
2008-07-21 06:30:00	QQQ	ETF	45.08	45.08	45.05	45.07	1500.0
2008-07-21 07:00:00	QQQ	ETF	45.09	45.23	45.09	45.17	11883.0
2008-07-21 07:30:00	QQQ	ETF	45.16	45.16	45.03	45.03	61441.0
2008-07-21 08:00:00	QQQ	ETF	45.04	45.08	44.97	45.07	775786.0
2008-07-21 08:30:00	QQQ	ETF	45.07	45.12	45.05	45.12	498783.0
2008-07-21 09:00:00	QQQ	ETF	45.11	45.12	45.0	45.01	461521.0
2008-07-21 09:30:00	QQQ	ETF	45.01	45.16	44.96	45.12	14483378.0
2008-07-21 10:00:00	QQQ	ETF	45.12	45.19	44.87	44.9	10667619.0
2008-07-21 10:30:00	QQQ	ETF	44.9	45.05	44.84	44.89	7989648.0
2008-07-21 11:00:00	QQQ	ETF	44.898	44.96	44.79	44.92	3799206.0
2008-07-21 11:30:00	QQQ	ETF	44.92	44.93	44.5	44.53	9817019.0
2008-07-21 12:00:00	QQQ	ETF	44.53	44.67	44.49	44.62	8616377.0
2008-07-21 12:30:00	QQQ	ETF	44.62	44.71	44.57	44.59	6568766.0
2008-07-21 13:00:00	QQQ	ETF	44.58	44.79	44.58	44.71	5261201.0

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

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