PREVIEW / etf_30min / 2008-02-25

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-02-25.parquet
  size:    160 KB
  rows:    5,778

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-02-25 04:00:00	SPY	ETF	136.12	136.12	136.12	136.12	1000.0
2008-02-25 04:30:00	SPY	ETF	136.24	136.33	136.24	136.33	600.0
2008-02-25 05:00:00	SPY	ETF	136.04	136.04	136.04	136.04	100.0
2008-02-25 05:30:00	SPY	ETF	136.09	136.1	136.09	136.1	6000.0
2008-02-25 06:00:00	SPY	ETF	136.25	136.26	136.04	136.09	16200.0
2008-02-25 06:30:00	SPY	ETF	136.01	136.06	136.0	136.0	24100.0
2008-02-25 07:00:00	SPY	ETF	136.02	136.05	135.8	135.84	220400.0
2008-02-25 07:30:00	SPY	ETF	135.84	135.9	135.65	135.78	434700.0
2008-02-25 08:00:00	SPY	ETF	135.75	135.87	135.48	135.53	613200.0
2008-02-25 08:30:00	SPY	ETF	135.52	135.64	135.45	135.61	390700.0
2008-02-25 09:00:00	SPY	ETF	135.61	135.68	135.55	135.56	643528.0
2008-02-25 09:30:00	SPY	ETF	135.54	135.85	134.85	134.92	17229425.0
2008-02-25 10:00:00	SPY	ETF	134.92	136.06	134.78	136.02	19170123.0
2008-02-25 10:30:00	SPY	ETF	136.02	136.52	135.81	136.44	12112610.0
2008-02-25 11:00:00	SPY	ETF	136.44	136.47	136.16	136.17	6569863.0
2008-02-25 11:30:00	SPY	ETF	136.17	136.24	135.52	135.59	7621344.0
2008-02-25 12:00:00	SPY	ETF	135.58	135.96	135.35	135.53	7981107.0
2008-02-25 12:30:00	SPY	ETF	135.53	135.88	135.43	135.74	4224301.0
2008-02-25 13:00:00	SPY	ETF	135.74	136.07	135.45	135.52	7725495.0
2008-02-25 13:30:00	SPY	ETF	135.54	135.82	135.25	135.73	6362677.0
2008-02-25 14:00:00	SPY	ETF	135.73	137.15	135.56	137.0	20678936.0
2008-02-25 14:30:00	SPY	ETF	137.0	137.27	135.4449	136.55	33259823.0
2008-02-25 15:00:00	SPY	ETF	136.55	137.1	136.1472	137.04	16673600.0
2008-02-25 15:30:00	SPY	ETF	137.05	137.65	136.7	137.31	19103242.0
2008-02-25 16:00:00	SPY	ETF	137.291	137.51	135.33	137.24	3970800.0
2008-02-25 16:30:00	SPY	ETF	137.25	137.31	136.8	137.28	1449600.0
2008-02-25 17:00:00	SPY	ETF	137.27	137.33	137.18	137.18	279700.0
2008-02-25 17:30:00	SPY	ETF	137.18	137.22	137.16	137.16	38500.0
2008-02-25 18:00:00	SPY	ETF	137.15	137.23	137.14	137.17	95100.0
2008-02-25 18:30:00	SPY	ETF	137.16	137.27	137.1	137.14	136800.0
2008-02-25 19:00:00	SPY	ETF	137.14	137.18	137.09	137.18	27600.0
2008-02-25 19:30:00	SPY	ETF	137.19	137.32	137.19	137.29	62100.0
2008-02-25 04:00:00	QQQ	ETF	43.84	43.84	43.84	43.84	120.0
2008-02-25 05:00:00	QQQ	ETF	43.85	43.85	43.85	43.85	200.0
2008-02-25 06:00:00	QQQ	ETF	43.85	43.85	43.79	43.79	12600.0
2008-02-25 06:30:00	QQQ	ETF	43.78	43.78	43.74	43.78	122500.0
2008-02-25 07:00:00	QQQ	ETF	43.76	43.78	43.74	43.77	88127.0
2008-02-25 07:30:00	QQQ	ETF	43.72	43.72	43.63	43.67	93339.0
2008-02-25 08:00:00	QQQ	ETF	43.68	43.69	43.57	43.59	642752.0
2008-02-25 08:30:00	QQQ	ETF	43.59	43.62	43.57	43.61	480119.0
2008-02-25 09:00:00	QQQ	ETF	43.6	43.64	43.6	43.62	638693.0
2008-02-25 09:30:00	QQQ	ETF	43.62	43.71	43.4	43.42	11116600.0
2008-02-25 10:00:00	QQQ	ETF	43.42	43.9401	43.34	43.94	18256647.0
2008-02-25 10:30:00	QQQ	ETF	43.94	43.95	43.75	43.88	8984724.0
2008-02-25 11:00:00	QQQ	ETF	43.89	43.92	43.8	43.81	7055938.0
2008-02-25 11:30:00	QQQ	ETF	43.81	43.83	43.63	43.66	4390414.0
2008-02-25 12:00:00	QQQ	ETF	43.65	43.7	43.52	43.57	4769625.0
2008-02-25 12:30:00	QQQ	ETF	43.57	43.7	43.51	43.68	4131067.0
2008-02-25 13:00:00	QQQ	ETF	43.68	43.75	43.46	43.48	4913316.0
2008-02-25 13:30:00	QQQ	ETF	43.49	43.56	43.34	43.52	6062038.0

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

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