PREVIEW / etf_30min / 2015-01-07

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-01-07.parquet
  size:    385 KB
  rows:    13,073

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
2015-01-07 04:00:00	SPY	ETF	200.29	200.52	200.29	200.39	26520.0
2015-01-07 04:30:00	SPY	ETF	200.15	200.68	200.15	200.6	2225.0
2015-01-07 05:00:00	SPY	ETF	200.63	200.84	200.57	200.84	22500.0
2015-01-07 05:30:00	SPY	ETF	200.9	201.23	200.84	201.17	330025.0
2015-01-07 06:00:00	SPY	ETF	201.1	201.21	201.05	201.06	22864.0
2015-01-07 06:30:00	SPY	ETF	201.03	201.14	200.92	201.01	80615.0
2015-01-07 07:00:00	SPY	ETF	201.01	201.33	201.01	201.09	138585.0
2015-01-07 07:30:00	SPY	ETF	201.1	201.45	200.98	201.45	249514.0
2015-01-07 08:00:00	SPY	ETF	201.26	201.77	201.03	201.54	640439.0
2015-01-07 08:30:00	SPY	ETF	201.54	201.54	201.21	201.39	832088.0
2015-01-07 09:00:00	SPY	ETF	201.37	201.59	201.36	201.42	1677134.0
2015-01-07 09:30:00	SPY	ETF	201.42	202.01	201.15	201.99	16633378.0
2015-01-07 10:00:00	SPY	ETF	201.99	202.21	201.48	201.67	9542342.0
2015-01-07 10:30:00	SPY	ETF	201.665	201.89	200.985	201.615	9270503.0
2015-01-07 11:00:00	SPY	ETF	201.63	201.8	200.88	201.1	8119539.0
2015-01-07 11:30:00	SPY	ETF	201.1	202.3	201.05	202.22	8997375.0
2015-01-07 12:00:00	SPY	ETF	202.22	202.72	202.05	202.41	10414869.0
2015-01-07 12:30:00	SPY	ETF	202.405	202.55	202.12	202.15	3334516.0
2015-01-07 13:00:00	SPY	ETF	202.155	202.37	201.72	201.8	4456332.0
2015-01-07 13:30:00	SPY	ETF	201.8	202.36	201.79	202.23	3357472.0
2015-01-07 14:00:00	SPY	ETF	202.22	202.54	201.82	202.1172	11831360.0
2015-01-07 14:30:00	SPY	ETF	202.125	202.5172	201.76	201.86	6573905.0
2015-01-07 15:00:00	SPY	ETF	201.87	202.24	201.76	202.09	5520553.0
2015-01-07 15:30:00	SPY	ETF	202.09	202.34	201.9	202.34	12433119.0
2015-01-07 16:00:00	SPY	ETF	202.34	202.43	201.5	202.37	5335607.0
2015-01-07 16:30:00	SPY	ETF	202.36	202.51	202.36	202.42	1907028.0
2015-01-07 17:00:00	SPY	ETF	202.42	202.47	202.41	202.44	1339328.0
2015-01-07 17:30:00	SPY	ETF	202.43	202.43	202.4	202.42	18167.0
2015-01-07 18:00:00	SPY	ETF	202.46	202.52	202.44	202.51	115459.0
2015-01-07 18:30:00	SPY	ETF	202.53	202.53	202.48	202.48	101139.0
2015-01-07 19:00:00	SPY	ETF	202.5	202.52	202.45	202.49	16215.0
2015-01-07 19:30:00	SPY	ETF	202.48	202.52	202.4	202.52	37749.0
2015-01-07 04:00:00	QQQ	ETF	100.44	100.53	100.44	100.53	400.0
2015-01-07 04:30:00	QQQ	ETF	100.52	100.52	100.52	100.52	2000.0
2015-01-07 05:30:00	QQQ	ETF	100.58	100.66	100.58	100.66	15100.0
2015-01-07 06:00:00	QQQ	ETF	100.65	100.74	100.65	100.74	4400.0
2015-01-07 07:00:00	QQQ	ETF	100.58	100.74	100.58	100.64	17778.0
2015-01-07 07:30:00	QQQ	ETF	100.68	100.8	100.63	100.8	55850.0
2015-01-07 08:00:00	QQQ	ETF	100.81	100.97	100.54	100.86	146857.0
2015-01-07 08:30:00	QQQ	ETF	100.84	100.84	100.64	100.69	72789.0
2015-01-07 09:00:00	QQQ	ETF	100.71	100.83	100.71	100.73	117810.0
2015-01-07 09:30:00	QQQ	ETF	100.73	101.15	100.485	101.14	5401115.0
2015-01-07 10:00:00	QQQ	ETF	101.13	101.339	100.88	101.01	3069493.0
2015-01-07 10:30:00	QQQ	ETF	101.02	101.185	100.71	101.05	2405232.0
2015-01-07 11:00:00	QQQ	ETF	101.06	101.15	100.58	100.76	3205316.0
2015-01-07 11:30:00	QQQ	ETF	100.75	101.42	100.73	101.4	2244911.0
2015-01-07 12:00:00	QQQ	ETF	101.39	101.6	101.28	101.44	2020488.0
2015-01-07 12:30:00	QQQ	ETF	101.43	101.5	101.305	101.37	555787.0
2015-01-07 13:00:00	QQQ	ETF	101.37	101.5	101.05	101.105	1687608.0
2015-01-07 13:30:00	QQQ	ETF	101.11	101.45	101.09	101.37	927771.0

> showing 50 of 13,073 rows — these rows as CSV

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