PREVIEW / etf_1hour / 2015-05-13

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-05-13.parquet
  size:    237 KB
  rows:    7,531

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-05-13 04:00:00	SPY	ETF	210.7	211.08	210.7	210.89	28252.0
2015-05-13 05:00:00	SPY	ETF	211.02	211.04	210.81	210.81	109260.0
2015-05-13 06:00:00	SPY	ETF	210.9	210.9	210.65	210.65	31426.0
2015-05-13 07:00:00	SPY	ETF	210.65	210.78	210.5	210.77	414063.0
2015-05-13 08:00:00	SPY	ETF	210.65	210.97	210.26	210.44	1304386.0
2015-05-13 09:00:00	SPY	ETF	210.41	211.22	210.15	210.81	12137159.0
2015-05-13 10:00:00	SPY	ETF	210.8	210.98	210.04	210.055	16121797.0
2015-05-13 11:00:00	SPY	ETF	210.06	210.44	209.85	210.2399	10173467.0
2015-05-13 12:00:00	SPY	ETF	210.24	210.42	209.92	210.19	5845190.0
2015-05-13 13:00:00	SPY	ETF	210.19	210.59	210.18	210.365	6163632.0
2015-05-13 14:00:00	SPY	ETF	210.37	210.4	209.87	209.97	7270371.0
2015-05-13 15:00:00	SPY	ETF	209.96	210.22	209.74	210.04	18644011.0
2015-05-13 16:00:00	SPY	ETF	210.03	210.9717	209.905	210.21	9891408.0
2015-05-13 17:00:00	SPY	ETF	210.19	210.27	210.09	210.15	90031.0
2015-05-13 18:00:00	SPY	ETF	210.17	210.35	210.16	210.18	83765.0
2015-05-13 19:00:00	SPY	ETF	210.23	210.24	210.199	210.22	12869.0
2015-05-13 03:00:00	QQQ	ETF	108.35	108.35	108.35	108.35	100.0
2015-05-13 04:00:00	QQQ	ETF	108.48	108.48	108.47	108.47	6350.0
2015-05-13 06:00:00	QQQ	ETF	108.37	108.37	108.3	108.34	18000.0
2015-05-13 07:00:00	QQQ	ETF	108.32	108.37	108.24	108.36	43216.0
2015-05-13 08:00:00	QQQ	ETF	108.36	108.48	108.13	108.3	239759.0
2015-05-13 09:00:00	QQQ	ETF	108.28	108.81	108.11	108.52	5012322.0
2015-05-13 10:00:00	QQQ	ETF	108.51	108.67	108.13	108.18	2963682.0
2015-05-13 11:00:00	QQQ	ETF	108.19	108.28	107.96	108.17	2457768.0
2015-05-13 12:00:00	QQQ	ETF	108.16	108.2373	107.94	108.09	1115275.0
2015-05-13 13:00:00	QQQ	ETF	108.1	108.32	108.08	108.261	1257126.0
2015-05-13 14:00:00	QQQ	ETF	108.27	108.28	107.915	108.0	2256567.0
2015-05-13 15:00:00	QQQ	ETF	108.0	108.1	107.84	107.98	3335777.0
2015-05-13 16:00:00	QQQ	ETF	107.98	108.09	107.8164	108.09	897546.0
2015-05-13 17:00:00	QQQ	ETF	108.09	108.09	108.01	108.08	2450.0
2015-05-13 18:00:00	QQQ	ETF	108.08	108.13	108.08	108.13	3750.0
2015-05-13 19:00:00	QQQ	ETF	108.07	108.07	108.06	108.06	6200.0
2015-05-13 04:00:00	IWM	ETF	123.23	123.23	123.23	123.23	100.0
2015-05-13 07:00:00	IWM	ETF	123.0	123.1	123.0	123.07	28600.0
2015-05-13 08:00:00	IWM	ETF	123.06	123.22	122.82	122.9	105240.0
2015-05-13 09:00:00	IWM	ETF	122.84	123.21	122.42	122.8	2592845.0
2015-05-13 10:00:00	IWM	ETF	122.8	122.965	122.22	122.25	3008826.0
2015-05-13 11:00:00	IWM	ETF	122.28	122.49	122.0	122.315	2451759.0
2015-05-13 12:00:00	IWM	ETF	122.32	122.63	122.18	122.57	1363479.0
2015-05-13 13:00:00	IWM	ETF	122.57	122.82	122.56	122.715	1093394.0
2015-05-13 14:00:00	IWM	ETF	122.72	122.74	122.37	122.51	1669048.0
2015-05-13 15:00:00	IWM	ETF	122.51	122.64	122.35	122.51	3131159.0
2015-05-13 16:00:00	IWM	ETF	122.5	122.58	122.35	122.58	4622947.0
2015-05-13 17:00:00	IWM	ETF	122.57	122.57	122.57	122.57	100.0
2015-05-13 07:00:00	DIA	ETF	181.2	181.28	181.2	181.28	3300.0
2015-05-13 08:00:00	DIA	ETF	181.35	181.49	180.84	180.85	2250.0
2015-05-13 09:00:00	DIA	ETF	180.75	181.44	180.6	181.16	585829.0
2015-05-13 10:00:00	DIA	ETF	181.16	181.39	180.67	180.69	557528.0
2015-05-13 11:00:00	DIA	ETF	180.6856	180.94	180.51	180.8	442377.0
2015-05-13 12:00:00	DIA	ETF	180.8	180.95	180.48	180.73	259544.0

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

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