PREVIEW / etf_30min / 2008-07-07

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-07.parquet
  size:    181 KB
  rows:    6,148

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-07 04:00:00	SPY	ETF	126.41	126.41	126.41	126.41	200.0
2008-07-07 04:30:00	SPY	ETF	126.0	126.0	126.0	126.0	100.0
2008-07-07 05:00:00	SPY	ETF	126.02	126.02	126.02	126.02	1500.0
2008-07-07 05:30:00	SPY	ETF	126.15	126.26	126.15	126.22	3620.0
2008-07-07 06:00:00	SPY	ETF	126.22	126.26	126.22	126.22	2600.0
2008-07-07 06:30:00	SPY	ETF	126.44	126.45	126.24	126.24	11200.0
2008-07-07 07:00:00	SPY	ETF	126.22	126.3	126.0	126.1	191590.0
2008-07-07 07:30:00	SPY	ETF	126.1	126.52	126.08	126.47	676776.0
2008-07-07 08:00:00	SPY	ETF	126.47	126.66	126.21	126.48	1452673.0
2008-07-07 08:30:00	SPY	ETF	126.48	126.48	126.28	126.32	1012843.0
2008-07-07 09:00:00	SPY	ETF	126.34	126.89	126.34	126.78	4309388.0
2008-07-07 09:30:00	SPY	ETF	126.79	127.34	126.74	127.2899	24784279.0
2008-07-07 10:00:00	SPY	ETF	127.28	127.33	126.66	126.84	25365956.0
2008-07-07 10:30:00	SPY	ETF	126.85	127.17	126.69	126.79	15473667.0
2008-07-07 11:00:00	SPY	ETF	126.79	127.0	126.46	126.93	17085952.0
2008-07-07 11:30:00	SPY	ETF	126.93	127.05	126.36	126.47	15501883.0
2008-07-07 12:00:00	SPY	ETF	126.47	126.61	125.06	125.11	29105901.0
2008-07-07 12:30:00	SPY	ETF	125.1	125.51	124.51	124.57	34672051.0
2008-07-07 13:00:00	SPY	ETF	124.57	124.95	124.0	124.36	30921975.0
2008-07-07 13:30:00	SPY	ETF	124.36	124.67	124.2	124.315	20455752.0
2008-07-07 14:00:00	SPY	ETF	124.33	124.65	123.92	124.46	30907493.0
2008-07-07 14:30:00	SPY	ETF	124.46	124.57	124.04	124.43	22288507.0
2008-07-07 15:00:00	SPY	ETF	124.42	127.02	124.41	125.82	38315687.0
2008-07-07 15:30:00	SPY	ETF	125.82	126.9	124.11	125.09	44894497.0
2008-07-07 16:00:00	SPY	ETF	125.088	126.9479	124.3862	125.06	6505834.0
2008-07-07 16:30:00	SPY	ETF	125.04	126.89	125.04	125.09	238287.0
2008-07-07 17:00:00	SPY	ETF	125.06	125.12	125.02	125.09	131831.0
2008-07-07 17:30:00	SPY	ETF	125.08	125.11	125.05	125.11	10420.0
2008-07-07 18:00:00	SPY	ETF	125.11	125.19	125.11	125.14	40252.0
2008-07-07 18:30:00	SPY	ETF	125.14	125.2	125.14	125.2	7897.0
2008-07-07 19:00:00	SPY	ETF	125.16	125.16	125.1	125.11	13900.0
2008-07-07 19:30:00	SPY	ETF	125.14	125.14	125.07	125.1	18790.0
2008-07-07 04:30:00	QQQ	ETF	44.75	44.75	44.69	44.69	6200.0
2008-07-07 06:30:00	QQQ	ETF	44.78	44.78	44.78	44.78	2000.0
2008-07-07 07:00:00	QQQ	ETF	44.7	44.7	44.67	44.67	74600.0
2008-07-07 07:30:00	QQQ	ETF	44.76	44.92	44.76	44.89	96798.0
2008-07-07 08:00:00	QQQ	ETF	44.9	44.97	44.89	44.92	593684.0
2008-07-07 08:30:00	QQQ	ETF	44.92	44.92	44.81	44.83	1146669.0
2008-07-07 09:00:00	QQQ	ETF	44.84	45.06	44.83	45.04	1482383.0
2008-07-07 09:30:00	QQQ	ETF	45.05	45.45	45.04	45.43	19361279.0
2008-07-07 10:00:00	QQQ	ETF	45.44	45.46	45.16	45.3	11728692.0
2008-07-07 10:30:00	QQQ	ETF	45.31	45.44	45.24	45.28	6834824.0
2008-07-07 11:00:00	QQQ	ETF	45.2805	45.35	45.15	45.32	5087133.0
2008-07-07 11:30:00	QQQ	ETF	45.32	45.37	45.09	45.18	8756559.0
2008-07-07 12:00:00	QQQ	ETF	45.18	45.24	44.59	44.6	11407790.0
2008-07-07 12:30:00	QQQ	ETF	44.61	44.85	44.47	44.49	12375572.0
2008-07-07 13:00:00	QQQ	ETF	44.4995	44.61	44.31	44.43	14726830.0
2008-07-07 13:30:00	QQQ	ETF	44.43	44.54	44.34	44.41	6401899.0
2008-07-07 14:00:00	QQQ	ETF	44.4026	44.6	44.24	44.49	12666055.0
2008-07-07 14:30:00	QQQ	ETF	44.49	44.6	44.34	44.47	7082402.0

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

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