PREVIEW / etf_30min / 2008-05-05

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-05-05.parquet
  size:    153 KB
  rows:    5,581

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-05 04:00:00	SPY	ETF	141.0	141.0	141.0	141.0	1000.0
2008-05-05 05:00:00	SPY	ETF	140.94	140.94	140.94	140.94	400.0
2008-05-05 05:30:00	SPY	ETF	140.97	140.97	140.97	140.97	100.0
2008-05-05 06:00:00	SPY	ETF	140.88	140.88	140.8	140.85	76000.0
2008-05-05 07:00:00	SPY	ETF	140.83	140.9	140.81	140.9	267799.0
2008-05-05 07:30:00	SPY	ETF	140.94	141.05	140.9	140.94	241200.0
2008-05-05 08:00:00	SPY	ETF	141.2	141.2	140.75	140.77	658695.0
2008-05-05 08:30:00	SPY	ETF	140.76	140.98	140.74	140.9	368406.0
2008-05-05 09:00:00	SPY	ETF	140.92	141.06	140.88	141.06	755188.0
2008-05-05 09:30:00	SPY	ETF	141.05	141.35	140.78	141.2	11355836.0
2008-05-05 10:00:00	SPY	ETF	141.2	141.61	140.81	140.84	20426943.0
2008-05-05 10:30:00	SPY	ETF	140.84	141.06	140.5	140.51	11463599.0
2008-05-05 11:00:00	SPY	ETF	140.51	140.95	140.41	140.66	12698643.0
2008-05-05 11:30:00	SPY	ETF	140.66	140.94	140.66	140.84	6198906.0
2008-05-05 12:00:00	SPY	ETF	140.84	140.94	140.54	140.7	6787428.0
2008-05-05 12:30:00	SPY	ETF	140.69	140.9	140.63	140.86	5544510.0
2008-05-05 13:00:00	SPY	ETF	140.86	140.9	140.62	140.635	4688816.0
2008-05-05 13:30:00	SPY	ETF	140.64	140.79	140.44	140.52	5332827.0
2008-05-05 14:00:00	SPY	ETF	140.53	140.72	140.42	140.69	5964577.0
2008-05-05 14:30:00	SPY	ETF	140.68	140.85	140.55	140.69	5530545.0
2008-05-05 15:00:00	SPY	ETF	140.68	140.9	140.67	140.8	6559065.0
2008-05-05 15:30:00	SPY	ETF	140.8	140.84	140.63	140.71	9969725.0
2008-05-05 16:00:00	SPY	ETF	140.7	141.43	140.6798	140.88	1336413.0
2008-05-05 16:30:00	SPY	ETF	140.86	140.91	140.8	140.83	208577.0
2008-05-05 17:00:00	SPY	ETF	140.82	140.89	140.82	140.89	91857.0
2008-05-05 17:30:00	SPY	ETF	140.87	140.87	140.85	140.87	6500.0
2008-05-05 18:00:00	SPY	ETF	140.87	140.94	140.82	140.88	16166.0
2008-05-05 18:30:00	SPY	ETF	140.85	140.85	140.82	140.82	1400.0
2008-05-05 19:00:00	SPY	ETF	140.87	140.88	140.87	140.88	3100.0
2008-05-05 19:30:00	SPY	ETF	140.88	140.88	140.88	140.88	300.0
2008-05-05 04:00:00	QQQ	ETF	48.57	48.57	48.57	48.57	100.0
2008-05-05 06:00:00	QQQ	ETF	48.59	48.59	48.59	48.59	200.0
2008-05-05 06:30:00	QQQ	ETF	48.61	48.64	48.61	48.63	400.0
2008-05-05 07:00:00	QQQ	ETF	48.63	48.64	48.6	48.64	68200.0
2008-05-05 07:30:00	QQQ	ETF	48.65	48.71	48.65	48.69	226900.0
2008-05-05 08:00:00	QQQ	ETF	48.69	48.7	48.63	48.63	441847.0
2008-05-05 08:30:00	QQQ	ETF	48.63	48.69	48.62	48.67	354681.0
2008-05-05 09:00:00	QQQ	ETF	48.67	48.74	48.67	48.73	812223.0
2008-05-05 09:30:00	QQQ	ETF	48.73	48.87	48.57	48.7801	10672478.0
2008-05-05 10:00:00	QQQ	ETF	48.78	49.03	48.64	48.67	13260562.0
2008-05-05 10:30:00	QQQ	ETF	48.67	48.77	48.55	48.57	5918107.0
2008-05-05 11:00:00	QQQ	ETF	48.58	48.85	48.52	48.5995	6727537.0
2008-05-05 11:30:00	QQQ	ETF	48.6	48.72	48.59	48.67	4417034.0
2008-05-05 12:00:00	QQQ	ETF	48.668	48.72	48.55	48.6001	2930785.0
2008-05-05 12:30:00	QQQ	ETF	48.61	48.71	48.5601	48.68	2469785.0
2008-05-05 13:00:00	QQQ	ETF	48.69	48.7	48.49	48.5	2606082.0
2008-05-05 13:30:00	QQQ	ETF	48.5	48.58	48.4	48.45	3950639.0
2008-05-05 14:00:00	QQQ	ETF	48.45	48.59	48.41	48.58	3192591.0
2008-05-05 14:30:00	QQQ	ETF	48.57	48.63	48.51	48.53	4343247.0
2008-05-05 15:00:00	QQQ	ETF	48.52	48.61	48.52	48.56	2606104.0

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

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