PREVIEW / etf_30min / 2015-07-22

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-07-22.parquet
  size:    376 KB
  rows:    12,716

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-07-22 04:00:00	SPY	ETF	211.29	211.34	211.29	211.34	700.0
2015-07-22 04:30:00	SPY	ETF	211.3	211.36	211.28	211.3	5500.0
2015-07-22 05:00:00	SPY	ETF	211.33	211.35	211.33	211.35	1300.0
2015-07-22 05:30:00	SPY	ETF	211.31	211.31	211.19	211.21	19945.0
2015-07-22 06:00:00	SPY	ETF	211.21	211.21	211.18	211.2	47995.0
2015-07-22 06:30:00	SPY	ETF	211.2	211.23	211.13	211.16	41089.0
2015-07-22 07:00:00	SPY	ETF	211.18	211.23	211.15	211.2	47662.0
2015-07-22 07:30:00	SPY	ETF	211.21	211.3	211.03	211.06	205666.0
2015-07-22 08:00:00	SPY	ETF	211.03	211.27	210.88	211.03	498313.0
2015-07-22 08:30:00	SPY	ETF	211.05	211.08	210.9	210.95	405553.0
2015-07-22 09:00:00	SPY	ETF	211.0	211.07	210.81	210.93	907280.0
2015-07-22 09:30:00	SPY	ETF	210.93	211.64	210.91	211.59	13809768.0
2015-07-22 10:00:00	SPY	ETF	211.61	211.77	211.46	211.5	9929557.0
2015-07-22 10:30:00	SPY	ETF	211.5	211.54	211.125	211.505	9534304.0
2015-07-22 11:00:00	SPY	ETF	211.51	211.54	211.055	211.15	4918305.0
2015-07-22 11:30:00	SPY	ETF	211.15	211.286	211.07	211.245	3190247.0
2015-07-22 12:00:00	SPY	ETF	211.24	211.36	211.01	211.15	3967135.0
2015-07-22 12:30:00	SPY	ETF	211.145	211.16	210.97	211.1387	4227610.0
2015-07-22 13:00:00	SPY	ETF	211.13	211.621	211.1	211.24	2297793.0
2015-07-22 13:30:00	SPY	ETF	211.25	211.32	211.15	211.25	2567541.0
2015-07-22 14:00:00	SPY	ETF	211.25	211.44	211.14	211.35	3264885.0
2015-07-22 14:30:00	SPY	ETF	211.35	211.485	211.28	211.46	2910382.0
2015-07-22 15:00:00	SPY	ETF	211.46	211.49	211.16	211.2049	5712491.0
2015-07-22 15:30:00	SPY	ETF	211.2	211.36	210.89	211.34	12024147.0
2015-07-22 16:00:00	SPY	ETF	211.33	211.44	211.18	211.43	5128027.0
2015-07-22 16:30:00	SPY	ETF	211.43	211.62	211.37	211.62	1766635.0
2015-07-22 17:00:00	SPY	ETF	211.59	211.6	211.53	211.54	175752.0
2015-07-22 17:30:00	SPY	ETF	211.56	211.57	211.52	211.52	31405.0
2015-07-22 18:00:00	SPY	ETF	211.55	211.6	211.5	211.54	139919.0
2015-07-22 18:30:00	SPY	ETF	211.54	211.55	211.54	211.55	1823.0
2015-07-22 19:00:00	SPY	ETF	211.55	211.56	211.54	211.54	26589.0
2015-07-22 19:30:00	SPY	ETF	211.57	211.65	211.54	211.63	126150.0
2015-07-22 04:00:00	QQQ	ETF	112.55	112.7	112.55	112.6	13295.0
2015-07-22 04:30:00	QQQ	ETF	112.73	112.73	112.68	112.73	3000.0
2015-07-22 05:30:00	QQQ	ETF	112.7	112.7	112.7	112.7	10300.0
2015-07-22 06:00:00	QQQ	ETF	112.7	112.7	112.65	112.65	10100.0
2015-07-22 06:30:00	QQQ	ETF	112.66	112.71	112.64	112.64	3830.0
2015-07-22 07:00:00	QQQ	ETF	112.65	112.66	112.56	112.58	41800.0
2015-07-22 07:30:00	QQQ	ETF	112.59	112.6	112.44	112.44	139424.0
2015-07-22 08:00:00	QQQ	ETF	112.44	112.6	112.33	112.33	178270.0
2015-07-22 08:30:00	QQQ	ETF	112.36	112.37	112.23	112.28	115374.0
2015-07-22 09:00:00	QQQ	ETF	112.28	112.33	112.01	112.17	477893.0
2015-07-22 09:30:00	QQQ	ETF	112.17	113.06	112.16	113.03	7424627.0
2015-07-22 10:00:00	QQQ	ETF	113.039	113.169	112.91	112.94	2770513.0
2015-07-22 10:30:00	QQQ	ETF	112.95	112.965	112.621	112.905	2096252.0
2015-07-22 11:00:00	QQQ	ETF	112.91	112.93	112.59	112.63	1640491.0
2015-07-22 11:30:00	QQQ	ETF	112.63	112.71	112.54	112.67	1026114.0
2015-07-22 12:00:00	QQQ	ETF	112.67	112.72	112.47	112.56	938345.0
2015-07-22 12:30:00	QQQ	ETF	112.56	112.63	112.41	112.62	1123704.0
2015-07-22 13:00:00	QQQ	ETF	112.62	112.76	112.61	112.65	1249850.0

> showing 50 of 12,716 rows — these rows as CSV

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