PREVIEW / etf_30min / 2010-04-12

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-04-12.parquet
  size:    244 KB
  rows:    8,344

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
2010-04-12 04:00:00	SPY	ETF	119.82	119.88	119.82	119.88	3068.0
2010-04-12 04:30:00	SPY	ETF	119.94	119.95	119.92	119.95	2200.0
2010-04-12 05:30:00	SPY	ETF	119.85	119.85	119.85	119.85	500.0
2010-04-12 06:30:00	SPY	ETF	119.81	119.83	119.75	119.77	9900.0
2010-04-12 07:00:00	SPY	ETF	119.8	119.86	119.6	119.64	120555.0
2010-04-12 07:30:00	SPY	ETF	119.63	119.75	119.6	119.74	211002.0
2010-04-12 08:00:00	SPY	ETF	119.72	119.79	119.61	119.67	339249.0
2010-04-12 08:30:00	SPY	ETF	119.67	119.71	119.58	119.64	566354.0
2010-04-12 09:00:00	SPY	ETF	119.64	119.8	119.6	119.71	996919.0
2010-04-12 09:30:00	SPY	ETF	119.7	119.96	119.59	119.59	15495120.0
2010-04-12 10:00:00	SPY	ETF	119.59	119.87	119.56	119.85	8140637.0
2010-04-12 10:30:00	SPY	ETF	119.85	119.9	119.68	119.87	6511836.0
2010-04-12 11:00:00	SPY	ETF	119.87	119.92	119.69	119.72	3857952.0
2010-04-12 11:30:00	SPY	ETF	119.715	119.88	119.66	119.82	6093678.0
2010-04-12 12:00:00	SPY	ETF	119.82	119.87	119.78	119.82	5163276.0
2010-04-12 12:30:00	SPY	ETF	119.82	119.91	119.76	119.9	6056028.0
2010-04-12 13:00:00	SPY	ETF	119.89	120.05	119.89	119.94	5092129.0
2010-04-12 13:30:00	SPY	ETF	119.94	120.01	119.8	119.81	5384122.0
2010-04-12 14:00:00	SPY	ETF	119.8	119.92	119.77	119.9	4777637.0
2010-04-12 14:30:00	SPY	ETF	119.9081	119.98	119.78	119.929	6166327.0
2010-04-12 15:00:00	SPY	ETF	119.928	119.97	119.67	119.76	10272174.0
2010-04-12 15:30:00	SPY	ETF	119.76	119.95	119.6	119.76	14344316.0
2010-04-12 16:00:00	SPY	ETF	119.76	119.93	119.63	119.72	4376235.0
2010-04-12 16:30:00	SPY	ETF	119.71	119.73	119.64	119.71	2391719.0
2010-04-12 17:00:00	SPY	ETF	119.71	119.73	119.64	119.67	186853.0
2010-04-12 17:30:00	SPY	ETF	119.66	119.7	119.65	119.68	18557.0
2010-04-12 18:00:00	SPY	ETF	119.7	119.7	119.68	119.7	4066.0
2010-04-12 18:30:00	SPY	ETF	119.69	119.69	119.66	119.66	4400.0
2010-04-12 19:00:00	SPY	ETF	119.66	119.66	119.62	119.62	17970.0
2010-04-12 19:30:00	SPY	ETF	119.62	119.67	119.6	119.63	51549.0
2010-04-12 06:00:00	QQQ	ETF	49.12	49.12	49.11	49.11	960.0
2010-04-12 06:30:00	QQQ	ETF	49.1	49.1	49.1	49.1	400.0
2010-04-12 07:00:00	QQQ	ETF	49.11	49.11	49.04	49.05	16500.0
2010-04-12 07:30:00	QQQ	ETF	49.02	49.07	49.02	49.07	26100.0
2010-04-12 08:00:00	QQQ	ETF	49.07	49.08	49.02	49.04	62633.0
2010-04-12 08:30:00	QQQ	ETF	49.05	49.06	49.02	49.04	176601.0
2010-04-12 09:00:00	QQQ	ETF	49.04	49.32	49.03	49.06	102581.0
2010-04-12 09:30:00	QQQ	ETF	49.06	49.2	48.94	48.97	8203049.0
2010-04-12 10:00:00	QQQ	ETF	48.97	49.11	48.95	49.11	4985257.0
2010-04-12 10:30:00	QQQ	ETF	49.1	49.12	49.01	49.12	4224644.0
2010-04-12 11:00:00	QQQ	ETF	49.11	49.14	49.03	49.05	1862402.0
2010-04-12 11:30:00	QQQ	ETF	49.0488	49.1	49.02	49.09	2387637.0
2010-04-12 12:00:00	QQQ	ETF	49.09	49.1435	49.05	49.085	1802729.0
2010-04-12 12:30:00	QQQ	ETF	49.0838	49.129	49.07	49.11	1260249.0
2010-04-12 13:00:00	QQQ	ETF	49.11	49.2	49.11	49.17	1621780.0
2010-04-12 13:30:00	QQQ	ETF	49.16	49.2	49.125	49.1299	1791490.0
2010-04-12 14:00:00	QQQ	ETF	49.13	49.16	49.11	49.159	1759202.0
2010-04-12 14:30:00	QQQ	ETF	49.1595	49.19	49.1199	49.18	1989625.0
2010-04-12 15:00:00	QQQ	ETF	49.1792	49.19	49.06	49.0901	2773415.0
2010-04-12 15:30:00	QQQ	ETF	49.1	49.11	49.03	49.07	4527236.0

> showing 50 of 8,344 rows — these rows as CSV

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