PREVIEW / etf_30min / 2017-09-19

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-09-19.parquet
  size:    426 KB
  rows:    14,855

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-09-19 04:00:00	SPY	ETF	249.74	249.77	249.71	249.77	2330.0
2017-09-19 04:30:00	SPY	ETF	249.77	249.77	249.77	249.77	300.0
2017-09-19 05:30:00	SPY	ETF	249.86	249.99	249.86	249.96	3867.0
2017-09-19 06:00:00	SPY	ETF	249.99	250.0	249.94	249.94	4976.0
2017-09-19 06:30:00	SPY	ETF	249.94	249.98	249.91	249.98	30006.0
2017-09-19 07:00:00	SPY	ETF	249.96	249.99	249.9	249.92	47892.0
2017-09-19 07:30:00	SPY	ETF	249.92	249.96	249.9	249.9	10733.0
2017-09-19 08:00:00	SPY	ETF	249.92	249.96	249.92	249.95	19699.0
2017-09-19 08:30:00	SPY	ETF	249.96	249.96	249.88	249.91	36389.0
2017-09-19 09:00:00	SPY	ETF	249.89	250.0	249.89	249.98	115426.0
2017-09-19 09:30:00	SPY	ETF	250.0	250.02	249.65	249.71	3914543.0
2017-09-19 10:00:00	SPY	ETF	249.72	249.96	249.68	249.9	2812108.0
2017-09-19 10:30:00	SPY	ETF	249.9	249.96	249.76	249.86	3310865.0
2017-09-19 11:00:00	SPY	ETF	249.85	249.87	249.6	249.83	1676879.0
2017-09-19 11:30:00	SPY	ETF	249.84	249.97	249.83	249.9	1383071.0
2017-09-19 12:00:00	SPY	ETF	249.9	250.06	249.89	250.01	2880443.0
2017-09-19 12:30:00	SPY	ETF	250.01	250.055	249.94	249.95	2126420.0
2017-09-19 13:00:00	SPY	ETF	249.96	250.04	249.87	249.925	1173771.0
2017-09-19 13:30:00	SPY	ETF	249.93	250.03	249.9047	250.0	2175496.0
2017-09-19 14:00:00	SPY	ETF	250.0	250.06	249.87	249.88	2907403.0
2017-09-19 14:30:00	SPY	ETF	249.89	250.05	249.87	249.925	2775928.0
2017-09-19 15:00:00	SPY	ETF	249.93	250.01	249.9	250.0	4018404.0
2017-09-19 15:30:00	SPY	ETF	250.0	250.07	249.88	249.97	6224779.0
2017-09-19 16:00:00	SPY	ETF	249.96	249.98	249.88	249.91	6771272.0
2017-09-19 16:30:00	SPY	ETF	249.97	249.97	249.82	249.82	2001829.0
2017-09-19 17:00:00	SPY	ETF	249.87	249.89	249.84	249.88	37203.0
2017-09-19 17:30:00	SPY	ETF	249.85	249.87	249.83	249.87	6621.0
2017-09-19 18:00:00	SPY	ETF	249.86	249.86	249.75	249.78	101844.0
2017-09-19 18:30:00	SPY	ETF	249.75	249.79	249.75	249.78	4192.0
2017-09-19 19:00:00	SPY	ETF	249.78	249.79	249.76	249.76	6401.0
2017-09-19 19:30:00	SPY	ETF	249.82	249.88	249.8	249.82	13414.0
2017-09-19 04:00:00	QQQ	ETF	145.52	145.54	145.5	145.51	723.0
2017-09-19 05:00:00	QQQ	ETF	145.61	145.61	145.61	145.61	600.0
2017-09-19 05:30:00	QQQ	ETF	145.62	145.7	145.62	145.7	1200.0
2017-09-19 06:00:00	QQQ	ETF	145.73	145.75	145.67	145.7	2720.0
2017-09-19 06:30:00	QQQ	ETF	145.7	145.72	145.67	145.72	3899.0
2017-09-19 07:00:00	QQQ	ETF	145.71	145.71	145.68	145.68	20491.0
2017-09-19 07:30:00	QQQ	ETF	145.71	145.77	145.71	145.75	9114.0
2017-09-19 08:00:00	QQQ	ETF	145.66	145.77	145.66	145.73	18695.0
2017-09-19 08:30:00	QQQ	ETF	145.73	145.73	145.65	145.66	20950.0
2017-09-19 09:00:00	QQQ	ETF	145.69	145.81	145.67	145.79	24701.0
2017-09-19 09:30:00	QQQ	ETF	145.81	145.87	145.31	145.41	3176137.0
2017-09-19 10:00:00	QQQ	ETF	145.41	145.795	145.41	145.76	1895694.0
2017-09-19 10:30:00	QQQ	ETF	145.75	145.8	145.61	145.74	1028972.0
2017-09-19 11:00:00	QQQ	ETF	145.75	145.75	145.39	145.6666	1508270.0
2017-09-19 11:30:00	QQQ	ETF	145.67	145.76	145.66	145.68	717992.0
2017-09-19 12:00:00	QQQ	ETF	145.68	146.01	145.68	145.8126	1091202.0
2017-09-19 12:30:00	QQQ	ETF	145.8101	145.87	145.7001	145.74	778016.0
2017-09-19 13:00:00	QQQ	ETF	145.73	145.77	145.63	145.69	511448.0
2017-09-19 13:30:00	QQQ	ETF	145.69	145.85	145.68	145.81	651886.0

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

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