PREVIEW / etf_30min / 2008-06-17

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-06-17.parquet
  size:    162 KB
  rows:    5,643

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-06-17 04:00:00	SPY	ETF	136.61	136.66	136.61	136.66	1200.0
2008-06-17 05:30:00	SPY	ETF	136.77	136.92	136.77	136.92	5200.0
2008-06-17 06:00:00	SPY	ETF	136.88	136.88	136.88	136.88	3000.0
2008-06-17 06:30:00	SPY	ETF	136.82	136.9	136.8	136.9	68600.0
2008-06-17 07:00:00	SPY	ETF	136.86	136.98	136.86	136.93	633750.0
2008-06-17 07:30:00	SPY	ETF	136.92	137.01	136.9	136.98	375350.0
2008-06-17 08:00:00	SPY	ETF	136.98	137.38	136.98	137.19	4701864.0
2008-06-17 08:30:00	SPY	ETF	137.08	137.31	136.81	137.28	3500998.0
2008-06-17 09:00:00	SPY	ETF	137.3	137.35	136.88	137.06	3510538.0
2008-06-17 09:30:00	SPY	ETF	137.07	137.12	135.91	136.69	26640607.0
2008-06-17 10:00:00	SPY	ETF	136.69	136.91	136.28	136.351	14608483.0
2008-06-17 10:30:00	SPY	ETF	136.34	136.7	136.26	136.57	13162153.0
2008-06-17 11:00:00	SPY	ETF	136.57	136.78	136.05	136.15	14248328.0
2008-06-17 11:30:00	SPY	ETF	136.14	136.25	135.93	136.03	15037942.0
2008-06-17 12:00:00	SPY	ETF	136.03	136.34	135.95	136.04	9342745.0
2008-06-17 12:30:00	SPY	ETF	136.03	136.15	135.7	135.9	10253830.0
2008-06-17 13:00:00	SPY	ETF	135.91	136.3	135.79	136.2	9928952.0
2008-06-17 13:30:00	SPY	ETF	136.2	136.36	136.07	136.2	7278855.0
2008-06-17 14:00:00	SPY	ETF	136.2	136.4417	135.84	135.87	10492874.0
2008-06-17 14:30:00	SPY	ETF	135.87	136.19	135.82	136.03	7159918.0
2008-06-17 15:00:00	SPY	ETF	136.04	136.11	135.55	135.73	13675795.0
2008-06-17 15:30:00	SPY	ETF	135.72	135.82	135.45	135.5	19249561.0
2008-06-17 16:00:00	SPY	ETF	135.44	136.92	135.37	135.45	4018692.0
2008-06-17 16:30:00	SPY	ETF	135.47	135.57	135.47	135.55	436900.0
2008-06-17 17:00:00	SPY	ETF	135.55	135.57	135.43	135.48	133003.0
2008-06-17 17:30:00	SPY	ETF	135.52	135.52	135.42	135.44	5065.0
2008-06-17 18:00:00	SPY	ETF	135.44	135.47	135.38	135.47	33075.0
2008-06-17 18:30:00	SPY	ETF	135.49	135.5	135.37	135.38	12800.0
2008-06-17 19:00:00	SPY	ETF	135.36	135.38	135.33	135.38	8855.0
2008-06-17 19:30:00	SPY	ETF	135.38	135.49	135.38	135.49	6100.0
2008-06-17 04:00:00	QQQ	ETF	48.85	48.86	48.85	48.85	800.0
2008-06-17 06:30:00	QQQ	ETF	48.94	48.94	48.94	48.94	5000.0
2008-06-17 07:00:00	QQQ	ETF	48.92	48.96	48.91	48.93	17500.0
2008-06-17 07:30:00	QQQ	ETF	48.92	48.95	48.9	48.92	468124.0
2008-06-17 08:00:00	QQQ	ETF	48.91	49.06	48.91	49.03	1835016.0
2008-06-17 08:30:00	QQQ	ETF	49.02	49.1	48.92	49.06	1737957.0
2008-06-17 09:00:00	QQQ	ETF	49.06	49.06	48.93	48.95	1297565.0
2008-06-17 09:30:00	QQQ	ETF	48.95	48.98	48.61	48.82	17152911.0
2008-06-17 10:00:00	QQQ	ETF	48.82	48.97	48.69	48.75	10824769.0
2008-06-17 10:30:00	QQQ	ETF	48.74	49.03	48.71	48.96	11166096.0
2008-06-17 11:00:00	QQQ	ETF	48.97	49.06	48.83	48.87	10813711.0
2008-06-17 11:30:00	QQQ	ETF	48.8699	48.89	48.71	48.76	8434664.0
2008-06-17 12:00:00	QQQ	ETF	48.76	48.86	48.74	48.77	4589607.0
2008-06-17 12:30:00	QQQ	ETF	48.78	48.81	48.61	48.7	6947812.0
2008-06-17 13:00:00	QQQ	ETF	48.7	48.83	48.64	48.8	4455400.0
2008-06-17 13:30:00	QQQ	ETF	48.81	48.87	48.77	48.8399	3458776.0
2008-06-17 14:00:00	QQQ	ETF	48.84	48.89	48.74	48.77	3793604.0
2008-06-17 14:30:00	QQQ	ETF	48.77	48.85	48.7	48.78	3781649.0
2008-06-17 15:00:00	QQQ	ETF	48.78	48.8	48.47	48.57	10032377.0
2008-06-17 15:30:00	QQQ	ETF	48.57	48.65	48.54	48.55	11480828.0

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

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