PREVIEW / etf_30min / 2008-07-10

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-10.parquet
  size:    174 KB
  rows:    5,950

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-10 04:00:00	SPY	ETF	124.83	124.95	124.83	124.95	8000.0
2008-07-10 04:30:00	SPY	ETF	124.8	124.99	124.7	124.99	27000.0
2008-07-10 05:00:00	SPY	ETF	125.05	125.05	124.93	124.93	51000.0
2008-07-10 05:30:00	SPY	ETF	124.93	124.93	124.87	124.87	200.0
2008-07-10 06:00:00	SPY	ETF	124.9	124.91	124.88	124.88	3000.0
2008-07-10 06:30:00	SPY	ETF	124.88	124.88	124.64	124.64	113500.0
2008-07-10 07:00:00	SPY	ETF	124.7	125.7	124.65	125.56	908897.0
2008-07-10 07:30:00	SPY	ETF	125.56	125.8	125.35	125.35	1452461.0
2008-07-10 08:00:00	SPY	ETF	125.35	125.71	124.67	125.37	4409775.0
2008-07-10 08:30:00	SPY	ETF	125.38	125.79	124.6	124.61	9907806.0
2008-07-10 09:00:00	SPY	ETF	124.57	124.64	124.1	124.46	8224887.0
2008-07-10 09:30:00	SPY	ETF	124.43	125.27	124.25	124.53	46210493.0
2008-07-10 10:00:00	SPY	ETF	124.53	124.68	123.65	124.18	48522975.0
2008-07-10 10:30:00	SPY	ETF	124.17	124.84	123.99	124.3	34781311.0
2008-07-10 11:00:00	SPY	ETF	124.31	124.84	124.08	124.36	27775593.0
2008-07-10 11:30:00	SPY	ETF	124.37	125.08	124.3	124.77	24736956.0
2008-07-10 12:00:00	SPY	ETF	124.78	125.37	124.78	124.88	20021001.0
2008-07-10 12:30:00	SPY	ETF	124.88	125.19	124.5	124.59	12224304.0
2008-07-10 13:00:00	SPY	ETF	124.59	125.33	124.59	125.24	17008238.0
2008-07-10 13:30:00	SPY	ETF	125.25	125.79	125.23	125.38	22796191.0
2008-07-10 14:00:00	SPY	ETF	125.39	125.41	124.15	124.37	29458399.0
2008-07-10 14:30:00	SPY	ETF	124.39	124.6	123.58	123.88	35457257.0
2008-07-10 15:00:00	SPY	ETF	123.8899	125.01	123.84	124.79	38347861.0
2008-07-10 15:30:00	SPY	ETF	124.78	125.41	124.21	125.38	37890664.0
2008-07-10 16:00:00	SPY	ETF	125.46	125.46	124.4373	125.39	6250364.0
2008-07-10 16:30:00	SPY	ETF	125.39	125.66	125.3	125.63	660325.0
2008-07-10 17:00:00	SPY	ETF	125.63	125.67	125.5	125.57	401512.0
2008-07-10 17:30:00	SPY	ETF	125.57	125.61	125.49	125.53	42075.0
2008-07-10 18:00:00	SPY	ETF	125.51	125.55	125.43	125.49	40996.0
2008-07-10 18:30:00	SPY	ETF	125.44	125.58	125.44	125.58	17361.0
2008-07-10 19:00:00	SPY	ETF	125.62	125.62	125.53	125.53	4900.0
2008-07-10 19:30:00	SPY	ETF	125.53	125.65	125.41	125.5	8590.0
2008-07-10 04:00:00	QQQ	ETF	45.0	45.0	45.0	45.0	500.0
2008-07-10 05:00:00	QQQ	ETF	45.03	45.03	45.03	45.03	300.0
2008-07-10 06:30:00	QQQ	ETF	44.91	44.91	44.89	44.89	1800.0
2008-07-10 07:00:00	QQQ	ETF	44.89	45.23	44.88	45.22	511867.0
2008-07-10 07:30:00	QQQ	ETF	45.21	45.29	45.1	45.1	672017.0
2008-07-10 08:00:00	QQQ	ETF	45.11	45.22	44.87	45.07	2183532.0
2008-07-10 08:30:00	QQQ	ETF	45.07	45.21	44.86	44.86	3003158.0
2008-07-10 09:00:00	QQQ	ETF	44.86	44.89	44.65	44.82	2383062.0
2008-07-10 09:30:00	QQQ	ETF	44.82	45.3	44.81	44.99	25032963.0
2008-07-10 10:00:00	QQQ	ETF	45.0	45.08	44.72	45.08	24927059.0
2008-07-10 10:30:00	QQQ	ETF	45.07	45.27	44.94	45.05	16841157.0
2008-07-10 11:00:00	QQQ	ETF	45.04	45.23	44.92	44.94	13444999.0
2008-07-10 11:30:00	QQQ	ETF	44.94	45.17	44.9	45.05	7682025.0
2008-07-10 12:00:00	QQQ	ETF	45.04	45.32	45.04	45.13	10686962.0
2008-07-10 12:30:00	QQQ	ETF	45.13	45.22	44.96	45.001	7205697.0
2008-07-10 13:00:00	QQQ	ETF	45.02	45.27	45.02	45.23	5330936.0
2008-07-10 13:30:00	QQQ	ETF	45.23	45.42	45.21	45.21	9731481.0
2008-07-10 14:00:00	QQQ	ETF	45.21	45.28	44.71	44.74	17668756.0

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

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