PREVIEW / etf_30min / 2006-02-07

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-02-07.parquet
  size:    62 KB
  rows:    2,172

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
2006-02-07 06:00:00	SPY	ETF	126.42	126.42	126.42	126.42	1500.0
2006-02-07 07:00:00	SPY	ETF	126.4	126.4	126.35	126.35	178900.0
2006-02-07 07:30:00	SPY	ETF	126.36	126.37	126.26	126.32	143900.0
2006-02-07 08:00:00	SPY	ETF	126.34	126.39	126.27	126.33	97100.0
2006-02-07 08:30:00	SPY	ETF	126.35	126.41	126.32	126.38	179600.0
2006-02-07 09:00:00	SPY	ETF	126.38	126.42	126.31	126.39	352400.0
2006-02-07 09:30:00	SPY	ETF	126.38	126.66	126.18	126.37	5117000.0
2006-02-07 10:00:00	SPY	ETF	126.37	126.6	126.01	126.14	6764900.0
2006-02-07 10:30:00	SPY	ETF	126.14	126.25	125.8	126.02	9810500.0
2006-02-07 11:00:00	SPY	ETF	126.02	126.41	126.0	126.26	4571600.0
2006-02-07 11:30:00	SPY	ETF	126.27	126.37	126.05	126.14	2923300.0
2006-02-07 12:00:00	SPY	ETF	126.14	126.22	125.89	125.97	3603600.0
2006-02-07 12:30:00	SPY	ETF	125.98	126.1	125.94	126.01	1855200.0
2006-02-07 13:00:00	SPY	ETF	126.02	126.03	125.5	125.67	6051300.0
2006-02-07 13:30:00	SPY	ETF	125.68	125.74	125.56	125.74	2950400.0
2006-02-07 14:00:00	SPY	ETF	125.74	125.92	125.57	125.85	3910900.0
2006-02-07 14:30:00	SPY	ETF	125.85	125.86	125.42	125.53	6347700.0
2006-02-07 15:00:00	SPY	ETF	125.53	125.59	125.4	125.49	5058400.0
2006-02-07 15:30:00	SPY	ETF	125.49	125.69	125.44	125.57	8637800.0
2006-02-07 16:00:00	SPY	ETF	125.57	125.67	125.48	125.54	675700.0
2006-02-07 16:30:00	SPY	ETF	125.55	125.68	125.54	125.68	128400.0
2006-02-07 17:00:00	SPY	ETF	125.68	125.7	125.64	125.7	231900.0
2006-02-07 17:30:00	SPY	ETF	125.73	125.77	125.7	125.71	254200.0
2006-02-07 18:00:00	SPY	ETF	125.75	125.75	125.69	125.7	15100.0
2006-02-07 18:30:00	SPY	ETF	125.7	125.74	125.7	125.7	2200.0
2006-02-07 19:00:00	SPY	ETF	125.74	125.74	125.74	125.74	600.0
2006-02-07 19:30:00	SPY	ETF	125.74	125.74	125.73	125.73	2400.0
2006-02-07 09:30:00	QQQ	ETF	40.74	40.93	40.1	40.76	8593400.0
2006-02-07 10:00:00	QQQ	ETF	40.76	40.88	40.64	40.69	8024800.0
2006-02-07 10:30:00	QQQ	ETF	40.67	40.72	40.53	40.67	7529100.0
2006-02-07 11:00:00	QQQ	ETF	40.67	40.82	40.1	40.74	6185200.0
2006-02-07 11:30:00	QQQ	ETF	40.73	40.77	40.63	40.69	3997900.0
2006-02-07 12:00:00	QQQ	ETF	40.69	40.72	40.55	40.59	4794900.0
2006-02-07 12:30:00	QQQ	ETF	40.58	40.68	40.56	40.64	2753900.0
2006-02-07 13:00:00	QQQ	ETF	40.65	40.65	40.44	40.54	6650100.0
2006-02-07 13:30:00	QQQ	ETF	40.54	40.58	40.48	40.56	4533900.0
2006-02-07 14:00:00	QQQ	ETF	40.55	40.68	40.5	40.66	4069200.0
2006-02-07 14:30:00	QQQ	ETF	40.66	40.67	40.48	40.55	5816100.0
2006-02-07 15:00:00	QQQ	ETF	40.54	40.62	40.49	40.58	4008800.0
2006-02-07 15:30:00	QQQ	ETF	40.58	40.67	40.56	40.65	9778800.0
2006-02-07 07:00:00	IWM	ETF	72.29	72.29	72.29	72.29	800.0
2006-02-07 08:00:00	IWM	ETF	72.35	72.35	72.2	72.24	22700.0
2006-02-07 08:30:00	IWM	ETF	72.21	72.33	72.21	72.25	10400.0
2006-02-07 09:00:00	IWM	ETF	72.26	72.43	72.24	72.26	92900.0
2006-02-07 09:30:00	IWM	ETF	72.27	72.59	72.12	72.34	5072300.0
2006-02-07 10:00:00	IWM	ETF	72.34	72.41	72.04	72.12	2816100.0
2006-02-07 10:30:00	IWM	ETF	72.11	72.13	71.71	71.8501	1881600.0
2006-02-07 11:00:00	IWM	ETF	71.85	72.09	71.81	72.02	1209600.0
2006-02-07 11:30:00	IWM	ETF	72.02	72.04	71.77	71.86	1669800.0
2006-02-07 12:00:00	IWM	ETF	71.86	71.89	71.45	71.48	3427300.0

> showing 50 of 2,172 rows — these rows as CSV

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