PREVIEW / etf_30min / 2010-08-04

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-08-04.parquet
  size:    253 KB
  rows:    8,455

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-08-04 04:00:00	SPY	ETF	112.15	112.15	112.11	112.11	700.0
2010-08-04 04:30:00	SPY	ETF	111.9	111.94	111.85	111.94	1170.0
2010-08-04 05:30:00	SPY	ETF	111.84	111.84	111.76	111.76	2550.0
2010-08-04 06:00:00	SPY	ETF	111.92	111.95	111.92	111.95	6000.0
2010-08-04 06:30:00	SPY	ETF	112.04	112.08	112.03	112.03	2200.0
2010-08-04 07:00:00	SPY	ETF	112.04	112.21	112.01	112.17	92900.0
2010-08-04 07:30:00	SPY	ETF	112.16	112.19	112.02	112.07	423655.0
2010-08-04 08:00:00	SPY	ETF	112.08	112.65	111.94	112.62	1790012.0
2010-08-04 08:30:00	SPY	ETF	112.6	112.66	112.27	112.53	1132865.0
2010-08-04 09:00:00	SPY	ETF	112.54	112.66	112.5	112.53	682131.0
2010-08-04 09:30:00	SPY	ETF	112.53	112.73	112.35	112.69	15303202.0
2010-08-04 10:00:00	SPY	ETF	112.7	113.03	112.2	112.39	26560804.0
2010-08-04 10:30:00	SPY	ETF	112.39	112.52	112.16	112.41	14744939.0
2010-08-04 11:00:00	SPY	ETF	112.41	112.66	112.33	112.6203	6779302.0
2010-08-04 11:30:00	SPY	ETF	112.63	112.78	112.54	112.61	5930882.0
2010-08-04 12:00:00	SPY	ETF	112.6075	112.9	112.55	112.8	5727283.0
2010-08-04 12:30:00	SPY	ETF	112.801	112.93	112.7	112.75	6913204.0
2010-08-04 13:00:00	SPY	ETF	112.74	112.79	112.45	112.5384	6789689.0
2010-08-04 13:30:00	SPY	ETF	112.54	112.69	112.46	112.589	4349251.0
2010-08-04 14:00:00	SPY	ETF	112.58	112.83	112.54	112.76	5836825.0
2010-08-04 14:30:00	SPY	ETF	112.76	112.91	112.66	112.84	9000240.0
2010-08-04 15:00:00	SPY	ETF	112.83	113.08	112.75	113.0301	11426447.0
2010-08-04 15:30:00	SPY	ETF	113.03	113.11	112.9	112.97	17491469.0
2010-08-04 16:00:00	SPY	ETF	112.98	113.05	112.165	113.0	12730860.0
2010-08-04 16:30:00	SPY	ETF	113.0	113.07	112.99	113.03	1350419.0
2010-08-04 17:00:00	SPY	ETF	113.03	113.03	112.9	112.94	178461.0
2010-08-04 17:30:00	SPY	ETF	112.95	113.0	112.92	112.95	38027.0
2010-08-04 18:00:00	SPY	ETF	112.95	112.97	112.91	112.91	53642.0
2010-08-04 18:30:00	SPY	ETF	112.91	112.91	112.85	112.86	63487.0
2010-08-04 19:00:00	SPY	ETF	112.85	112.86	112.82	112.85	9000.0
2010-08-04 19:30:00	SPY	ETF	112.85	113.0	112.85	112.99	50707.0
2010-08-04 04:00:00	QQQ	ETF	46.49	46.49	46.41	46.41	2900.0
2010-08-04 05:30:00	QQQ	ETF	46.36	46.36	46.36	46.36	200.0
2010-08-04 06:30:00	QQQ	ETF	46.43	46.43	46.43	46.43	100.0
2010-08-04 07:00:00	QQQ	ETF	46.45	46.56	46.44	46.56	235604.0
2010-08-04 07:30:00	QQQ	ETF	46.53	46.55	46.48	46.48	81608.0
2010-08-04 08:00:00	QQQ	ETF	46.48	46.76	46.45	46.75	659815.0
2010-08-04 08:30:00	QQQ	ETF	46.74	46.75	46.66	46.69	312787.0
2010-08-04 09:00:00	QQQ	ETF	46.7	46.73	46.68	46.68	111071.0
2010-08-04 09:30:00	QQQ	ETF	46.69	46.89	46.64	46.7896	6128774.0
2010-08-04 10:00:00	QQQ	ETF	46.79	46.93	46.5	46.56	7235263.0
2010-08-04 10:30:00	QQQ	ETF	46.57	46.67	46.5	46.63	5015161.0
2010-08-04 11:00:00	QQQ	ETF	46.63	46.82	46.6	46.8	2194947.0
2010-08-04 11:30:00	QQQ	ETF	46.8	46.84	46.7301	46.745	2275107.0
2010-08-04 12:00:00	QQQ	ETF	46.74	46.905	46.73	46.862	1387614.0
2010-08-04 12:30:00	QQQ	ETF	46.87	46.96	46.79	46.87	2008953.0
2010-08-04 13:00:00	QQQ	ETF	46.875	46.8999	46.71	46.741	2751825.0
2010-08-04 13:30:00	QQQ	ETF	46.7425	46.82	46.72	46.78	1345956.0
2010-08-04 14:00:00	QQQ	ETF	46.78	46.89	46.77	46.87	1669046.0
2010-08-04 14:30:00	QQQ	ETF	46.87	46.92	46.8199	46.88	1932620.0

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

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