PREVIEW / etf_30min / 2009-12-04

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-04.parquet
  size:    241 KB
  rows:    8,017

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-12-04 04:30:00	SPY	ETF	110.44	110.5	110.44	110.5	1734.0
2009-12-04 05:30:00	SPY	ETF	110.45	110.45	110.45	110.45	100.0
2009-12-04 06:00:00	SPY	ETF	110.48	110.5	110.45	110.46	7300.0
2009-12-04 06:30:00	SPY	ETF	110.46	110.46	110.46	110.46	2050.0
2009-12-04 07:00:00	SPY	ETF	110.5	110.57	110.48	110.5	40923.0
2009-12-04 07:30:00	SPY	ETF	110.49	110.52	110.47	110.47	214442.0
2009-12-04 08:00:00	SPY	ETF	110.47	111.14	109.83	110.67	1188038.0
2009-12-04 08:30:00	SPY	ETF	110.64	111.88	110.28	111.59	17530736.0
2009-12-04 09:00:00	SPY	ETF	111.59	111.92	111.41	111.85	4281615.0
2009-12-04 09:30:00	SPY	ETF	111.84	112.38	111.65	112.17	30216796.0
2009-12-04 10:00:00	SPY	ETF	112.17	112.24	111.8	111.98	21639608.0
2009-12-04 10:30:00	SPY	ETF	111.97	112.05	111.56	111.64	16408269.0
2009-12-04 11:00:00	SPY	ETF	111.65	111.71	111.18	111.18	17354123.0
2009-12-04 11:30:00	SPY	ETF	111.19	111.26	110.04	110.55	45645887.0
2009-12-04 12:00:00	SPY	ETF	110.53	110.9904	110.48	110.6719	12712332.0
2009-12-04 12:30:00	SPY	ETF	110.67	110.98	110.67	110.89	8856019.0
2009-12-04 13:00:00	SPY	ETF	110.88	111.07	110.67	110.69	7175369.0
2009-12-04 13:30:00	SPY	ETF	110.69	110.81	110.31	110.38	9874890.0
2009-12-04 14:00:00	SPY	ETF	110.38	110.5	110.06	110.2965	16632510.0
2009-12-04 14:30:00	SPY	ETF	110.2905	110.85	110.29	110.67	14330798.0
2009-12-04 15:00:00	SPY	ETF	110.67	111.17	110.58	111.02	14541820.0
2009-12-04 15:30:00	SPY	ETF	111.02	111.14	110.74	111.029	22025707.0
2009-12-04 16:00:00	SPY	ETF	111.0	112.31	110.2808	111.25	10336900.0
2009-12-04 16:30:00	SPY	ETF	111.0358	111.31	111.0358	111.31	244299.0
2009-12-04 17:00:00	SPY	ETF	111.26	111.31	110.4217	111.2	3050890.0
2009-12-04 17:30:00	SPY	ETF	111.23	111.27	111.19	111.26	13885.0
2009-12-04 18:00:00	SPY	ETF	111.24	111.27	111.21	111.25	9341.0
2009-12-04 18:30:00	SPY	ETF	111.25	111.26	111.21	111.23	1700.0
2009-12-04 19:00:00	SPY	ETF	111.27	111.29	111.27	111.27	14941.0
2009-12-04 19:30:00	SPY	ETF	111.26	111.27	111.24	111.26	6144.0
2009-12-04 07:00:00	QQQ	ETF	43.88	43.88	43.86	43.86	1200.0
2009-12-04 07:30:00	QQQ	ETF	43.9	43.91	43.88	43.89	70700.0
2009-12-04 08:00:00	QQQ	ETF	43.9	44.15	43.85	44.1	401607.0
2009-12-04 08:30:00	QQQ	ETF	44.15	44.48	43.86	44.38	2981479.0
2009-12-04 09:00:00	QQQ	ETF	44.39	44.49	44.34	44.45	1292156.0
2009-12-04 09:30:00	QQQ	ETF	44.45	44.73	44.38	44.66	13783680.0
2009-12-04 10:00:00	QQQ	ETF	44.67	44.688	44.53	44.636	10279981.0
2009-12-04 10:30:00	QQQ	ETF	44.6393	44.69	44.52	44.55	5930419.0
2009-12-04 11:00:00	QQQ	ETF	44.55	44.55	44.3	44.3	7998585.0
2009-12-04 11:30:00	QQQ	ETF	44.3	44.3099	43.66	43.9	23580020.0
2009-12-04 12:00:00	QQQ	ETF	43.9074	44.02	43.87	43.98	5211498.0
2009-12-04 12:30:00	QQQ	ETF	43.99	44.08	43.98	44.02	4958094.0
2009-12-04 13:00:00	QQQ	ETF	44.02	44.08	43.92	43.94	2402113.0
2009-12-04 13:30:00	QQQ	ETF	43.93	44.04	43.83	43.86	4712413.0
2009-12-04 14:00:00	QQQ	ETF	43.86	43.915	43.73	43.83	6280711.0
2009-12-04 14:30:00	QQQ	ETF	43.83	44.04	43.83	44.01	5666540.0
2009-12-04 15:00:00	QQQ	ETF	44.01	44.23	43.97	44.16	7190691.0
2009-12-04 15:30:00	QQQ	ETF	44.16	44.21	44.04	44.12	9294322.0
2009-12-04 16:00:00	QQQ	ETF	44.11	44.24	43.9372	44.19	2863652.0
2009-12-04 16:30:00	QQQ	ETF	44.2	44.2	43.9115	44.2	3412500.0

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

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