PREVIEW / etf_30min / 2017-08-23

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-08-23.parquet
  size:    422 KB
  rows:    14,491

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
2017-08-23 04:00:00	SPY	ETF	245.21	245.21	244.8	245.07	9973.0
2017-08-23 04:30:00	SPY	ETF	245.02	245.02	244.99	244.99	2250.0
2017-08-23 05:00:00	SPY	ETF	245.03	245.03	244.97	244.97	9900.0
2017-08-23 05:30:00	SPY	ETF	244.99	245.05	244.97	244.98	10200.0
2017-08-23 06:00:00	SPY	ETF	244.95	244.95	244.84	244.88	27882.0
2017-08-23 06:30:00	SPY	ETF	244.9	244.98	244.82	244.98	19460.0
2017-08-23 07:00:00	SPY	ETF	245.0	245.05	244.97	244.99	53322.0
2017-08-23 07:30:00	SPY	ETF	245.0	245.0	244.58	244.71	266364.0
2017-08-23 08:00:00	SPY	ETF	244.7	245.3745	244.65	244.65	221187.0
2017-08-23 08:30:00	SPY	ETF	244.64	244.66	244.5	244.56	654188.0
2017-08-23 09:00:00	SPY	ETF	244.55	244.56	244.34	244.36	511725.0
2017-08-23 09:30:00	SPY	ETF	244.33	244.83	244.16	244.79	6843511.0
2017-08-23 10:00:00	SPY	ETF	244.79	244.89	244.3959	244.68	3497145.0
2017-08-23 10:30:00	SPY	ETF	244.69	244.94	244.54	244.65	2733725.0
2017-08-23 11:00:00	SPY	ETF	244.656	244.93	244.53	244.92	2320445.0
2017-08-23 11:30:00	SPY	ETF	244.92	245.05	244.77	244.94	2330922.0
2017-08-23 12:00:00	SPY	ETF	244.93	245.04	244.8	244.82	2566428.0
2017-08-23 12:30:00	SPY	ETF	244.82	244.87	244.64	244.76	1789170.0
2017-08-23 13:00:00	SPY	ETF	244.76	244.8	244.48	244.61	1603539.0
2017-08-23 13:30:00	SPY	ETF	244.605	244.65	244.43	244.555	1625626.0
2017-08-23 14:00:00	SPY	ETF	244.56	244.79	244.49	244.61	2287227.0
2017-08-23 14:30:00	SPY	ETF	244.62	244.86	244.59	244.78	1455171.0
2017-08-23 15:00:00	SPY	ETF	244.78	244.935	244.73	244.8601	1898587.0
2017-08-23 15:30:00	SPY	ETF	244.87	245.03	244.52	244.538	7600554.0
2017-08-23 16:00:00	SPY	ETF	244.54	244.61	244.37	244.38	5363920.0
2017-08-23 16:30:00	SPY	ETF	244.38	244.56	244.22	244.26	1448151.0
2017-08-23 17:00:00	SPY	ETF	244.26	244.27	244.17	244.22	96731.0
2017-08-23 17:30:00	SPY	ETF	244.22	244.24	244.19	244.24	15701.0
2017-08-23 18:00:00	SPY	ETF	244.25	244.29	243.94	244.03	128177.0
2017-08-23 18:30:00	SPY	ETF	244.03	244.06	243.81	244.02	25175.0
2017-08-23 19:00:00	SPY	ETF	243.99	244.05	243.97	244.04	15727.0
2017-08-23 19:30:00	SPY	ETF	244.04	244.05	243.89	243.89	30759.0
2017-08-23 04:00:00	QQQ	ETF	143.1	143.1	143.01	143.05	1551.0
2017-08-23 04:30:00	QQQ	ETF	143.0	143.0	143.0	143.0	200.0
2017-08-23 05:00:00	QQQ	ETF	143.0	143.01	142.97	142.97	5816.0
2017-08-23 05:30:00	QQQ	ETF	143.01	143.01	142.98	142.98	500.0
2017-08-23 06:00:00	QQQ	ETF	142.9	142.9	142.9	142.9	300.0
2017-08-23 06:30:00	QQQ	ETF	142.9	142.91	142.85	142.89	1550.0
2017-08-23 07:00:00	QQQ	ETF	143.01	143.02	142.97	142.99	6000.0
2017-08-23 07:30:00	QQQ	ETF	142.95	142.95	142.73	142.76	153743.0
2017-08-23 08:00:00	QQQ	ETF	142.97	142.97	142.75	142.78	144538.0
2017-08-23 08:30:00	QQQ	ETF	142.74	142.75	142.59	142.65	212908.0
2017-08-23 09:00:00	QQQ	ETF	142.6	142.61	142.49	142.5	330553.0
2017-08-23 09:30:00	QQQ	ETF	142.5	142.88	142.38	142.84	3211918.0
2017-08-23 10:00:00	QQQ	ETF	142.84	142.84	142.42	142.67	2042370.0
2017-08-23 10:30:00	QQQ	ETF	142.67	142.7953	142.49	142.54	1180824.0
2017-08-23 11:00:00	QQQ	ETF	142.53	142.9	142.51	142.88	1583883.0
2017-08-23 11:30:00	QQQ	ETF	142.8775	142.97	142.75	142.85	2138938.0
2017-08-23 12:00:00	QQQ	ETF	142.85	142.925	142.64	142.65	1314166.0
2017-08-23 12:30:00	QQQ	ETF	142.65	142.73	142.55	142.699	678218.0

> showing 50 of 14,491 rows — these rows as CSV

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