PREVIEW / etf_30min / 2009-11-23

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-11-23.parquet
  size:    238 KB
  rows:    7,984

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-11-23 04:00:00	SPY	ETF	110.47	110.57	110.47	110.5	3450.0
2009-11-23 04:30:00	SPY	ETF	110.54	110.54	110.44	110.44	11500.0
2009-11-23 05:00:00	SPY	ETF	110.51	110.64	110.51	110.54	6950.0
2009-11-23 05:30:00	SPY	ETF	110.59	110.67	110.54	110.67	1200.0
2009-11-23 06:00:00	SPY	ETF	110.6	110.6	110.57	110.57	25200.0
2009-11-23 06:30:00	SPY	ETF	110.59	110.69	110.59	110.61	34150.0
2009-11-23 07:00:00	SPY	ETF	110.62	110.71	110.57	110.62	271400.0
2009-11-23 07:30:00	SPY	ETF	110.63	110.65	110.52	110.56	237778.0
2009-11-23 08:00:00	SPY	ETF	110.57	110.57	110.47	110.57	1590634.0
2009-11-23 08:30:00	SPY	ETF	110.57	110.75	110.37	110.59	423943.0
2009-11-23 09:00:00	SPY	ETF	110.6	110.86	109.4	110.72	1903870.0
2009-11-23 09:30:00	SPY	ETF	110.72	111.74	110.69	111.53	24681531.0
2009-11-23 10:00:00	SPY	ETF	111.535	111.63	111.25	111.48	19905623.0
2009-11-23 10:30:00	SPY	ETF	111.48	111.55	111.22	111.3	12064584.0
2009-11-23 11:00:00	SPY	ETF	111.3	111.38	111.23	111.24	6199285.0
2009-11-23 11:30:00	SPY	ETF	111.24	111.34	111.05	111.07	7138672.0
2009-11-23 12:00:00	SPY	ETF	111.07	111.17	110.98	110.98	5757874.0
2009-11-23 12:30:00	SPY	ETF	110.99	111.08	110.85	111.0	6684541.0
2009-11-23 13:00:00	SPY	ETF	111.01	111.05	110.87	110.9699	6056816.0
2009-11-23 13:30:00	SPY	ETF	110.97	111.07	110.81	110.89	8128061.0
2009-11-23 14:00:00	SPY	ETF	110.88	110.91	110.7	110.84	6710632.0
2009-11-23 14:30:00	SPY	ETF	110.84	110.94	110.82	110.83	4004978.0
2009-11-23 15:00:00	SPY	ETF	110.84	111.02	110.83	110.86	7058228.0
2009-11-23 15:30:00	SPY	ETF	110.86	110.98	110.6	110.91	18936435.0
2009-11-23 16:00:00	SPY	ETF	110.91	111.45	110.74	110.85	7258125.0
2009-11-23 16:30:00	SPY	ETF	110.84	110.97	110.78	110.79	416039.0
2009-11-23 17:00:00	SPY	ETF	110.78	110.8	110.74	110.76	114106.0
2009-11-23 17:30:00	SPY	ETF	110.76	110.76	110.7	110.72	72503.0
2009-11-23 18:00:00	SPY	ETF	110.74	110.84	110.74	110.83	79990.0
2009-11-23 18:30:00	SPY	ETF	110.82	110.82	110.78	110.78	5000.0
2009-11-23 19:00:00	SPY	ETF	110.75	110.78	110.72	110.77	9200.0
2009-11-23 19:30:00	SPY	ETF	110.75	110.76	110.69	110.7	12285.0
2009-11-23 04:00:00	QQQ	ETF	43.81	43.81	43.8	43.8	2282.0
2009-11-23 04:30:00	QQQ	ETF	43.84	43.86	43.66	43.86	1055.0
2009-11-23 05:30:00	QQQ	ETF	43.84	43.84	43.84	43.84	8000.0
2009-11-23 06:30:00	QQQ	ETF	43.85	43.9	43.85	43.9	105050.0
2009-11-23 07:00:00	QQQ	ETF	43.86	43.89	43.85	43.87	109583.0
2009-11-23 07:30:00	QQQ	ETF	43.87	43.88	43.82	43.82	228654.0
2009-11-23 08:00:00	QQQ	ETF	43.81	43.82	43.76	43.82	717901.0
2009-11-23 08:30:00	QQQ	ETF	43.82	43.84	43.77	43.83	422873.0
2009-11-23 09:00:00	QQQ	ETF	43.84	43.95	43.83	43.88	1107944.0
2009-11-23 09:30:00	QQQ	ETF	43.87	44.4	43.86	44.33	15134127.0
2009-11-23 10:00:00	QQQ	ETF	44.3	44.37	44.25	44.32	12584164.0
2009-11-23 10:30:00	QQQ	ETF	44.33	44.36	44.19	44.205	7279765.0
2009-11-23 11:00:00	QQQ	ETF	44.2	44.245	44.17	44.1701	2743609.0
2009-11-23 11:30:00	QQQ	ETF	44.17	44.19	44.08	44.09	3074829.0
2009-11-23 12:00:00	QQQ	ETF	44.0907	44.14	44.08	44.08	2919344.0
2009-11-23 12:30:00	QQQ	ETF	44.09	44.13	44.01	44.11	4913180.0
2009-11-23 13:00:00	QQQ	ETF	44.11	44.14	44.05	44.1	3689013.0
2009-11-23 13:30:00	QQQ	ETF	44.09	44.14	44.03	44.07	3722506.0

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

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