PREVIEW / etf_30min / 2009-09-04

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-04.parquet
  size:    223 KB
  rows:    7,289

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
2009-09-04 04:00:00	SPY	ETF	100.94	101.01	100.94	100.98	1700.0
2009-09-04 04:30:00	SPY	ETF	100.98	101.08	100.98	101.08	700.0
2009-09-04 05:00:00	SPY	ETF	101.1	101.16	101.06	101.06	1190.0
2009-09-04 05:30:00	SPY	ETF	101.03	101.03	101.0	101.0	1200.0
2009-09-04 06:00:00	SPY	ETF	100.9	100.9	100.9	100.9	400.0
2009-09-04 06:30:00	SPY	ETF	100.91	100.91	100.91	100.91	10650.0
2009-09-04 07:00:00	SPY	ETF	100.93	101.12	100.93	101.01	169051.0
2009-09-04 07:30:00	SPY	ETF	100.98	101.06	100.97	101.06	236298.0
2009-09-04 08:00:00	SPY	ETF	100.41	101.16	100.41	100.95	2267823.0
2009-09-04 08:30:00	SPY	ETF	100.92	101.43	100.51	100.85	10925588.0
2009-09-04 09:00:00	SPY	ETF	100.83	100.94	100.59	100.86	2998445.0
2009-09-04 09:30:00	SPY	ETF	100.85	101.14	100.55	100.66	19887335.0
2009-09-04 10:00:00	SPY	ETF	100.67	101.15	100.65	101.03	10572924.0
2009-09-04 10:30:00	SPY	ETF	101.04	101.28	101.01	101.22	7448706.0
2009-09-04 11:00:00	SPY	ETF	101.22	101.23	100.88	100.99	5806379.0
2009-09-04 11:30:00	SPY	ETF	101.0	101.33	100.95	101.33	4561891.0
2009-09-04 12:00:00	SPY	ETF	101.34	101.84	101.31	101.74	13032753.0
2009-09-04 12:30:00	SPY	ETF	101.74	101.82	101.67	101.8	5359903.0
2009-09-04 13:00:00	SPY	ETF	101.8	102.05	101.71	101.99	7391193.0
2009-09-04 13:30:00	SPY	ETF	101.98	102.01	101.72	101.72	5794872.0
2009-09-04 14:00:00	SPY	ETF	101.74	101.8893	101.66	101.67	3491979.0
2009-09-04 14:30:00	SPY	ETF	101.67	101.96	101.62	101.94	7956605.0
2009-09-04 15:00:00	SPY	ETF	101.93	102.0	101.72	101.87	8581849.0
2009-09-04 15:30:00	SPY	ETF	101.87	102.09	101.74	102.07	18601720.0
2009-09-04 16:00:00	SPY	ETF	102.07	102.2215	100.69	101.95	6480190.0
2009-09-04 16:30:00	SPY	ETF	101.94	101.99	100.7	101.9	530086.0
2009-09-04 17:00:00	SPY	ETF	101.9	101.95	101.87	101.9	64304.0
2009-09-04 17:30:00	SPY	ETF	101.91	101.91	101.85	101.9	36218.0
2009-09-04 18:00:00	SPY	ETF	101.9	102.0	101.9	101.97	32042.0
2009-09-04 18:30:00	SPY	ETF	101.99	102.01	101.97	102.0	17758.0
2009-09-04 19:00:00	SPY	ETF	102.0	102.0	101.96	101.97	9350.0
2009-09-04 19:30:00	SPY	ETF	101.99	102.02	101.96	102.02	17733.0
2009-09-04 04:30:00	QQQ	ETF	39.69	39.69	39.68	39.68	467.0
2009-09-04 07:00:00	QQQ	ETF	39.67	39.72	39.67	39.69	6200.0
2009-09-04 07:30:00	QQQ	ETF	39.67	39.68	39.64	39.68	37201.0
2009-09-04 08:00:00	QQQ	ETF	39.69	39.73	39.58	39.58	1147931.0
2009-09-04 08:30:00	QQQ	ETF	39.55	39.82	39.28	39.59	3705325.0
2009-09-04 09:00:00	QQQ	ETF	39.58	39.66	39.53	39.59	635895.0
2009-09-04 09:30:00	QQQ	ETF	39.59	39.81	39.52	39.56	10260482.0
2009-09-04 10:00:00	QQQ	ETF	39.56	39.79	39.55	39.76	3002925.0
2009-09-04 10:30:00	QQQ	ETF	39.75	39.92	39.74	39.9	5063949.0
2009-09-04 11:00:00	QQQ	ETF	39.91	39.91	39.76	39.82	2205309.0
2009-09-04 11:30:00	QQQ	ETF	39.82	40.01	39.78	40.0	2553523.0
2009-09-04 12:00:00	QQQ	ETF	40.0	40.3	39.99	40.2502	8347803.0
2009-09-04 12:30:00	QQQ	ETF	40.25	40.285	40.21	40.27	3143565.0
2009-09-04 13:00:00	QQQ	ETF	40.28	40.38	40.23	40.32	4882312.0
2009-09-04 13:30:00	QQQ	ETF	40.33	40.34	40.19	40.19	2358193.0
2009-09-04 14:00:00	QQQ	ETF	40.19	40.24	40.17	40.18	3029532.0
2009-09-04 14:30:00	QQQ	ETF	40.17	40.28	40.14	40.28	2949521.0
2009-09-04 15:00:00	QQQ	ETF	40.27	40.3	40.17	40.26	3219302.0

> showing 50 of 7,289 rows — these rows as CSV

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