PREVIEW / etf_30min / 2017-08-15

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-08-15.parquet
  size:    428 KB
  rows:    14,765

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-15 04:00:00	SPY	ETF	246.72	246.98	246.72	246.98	6320.0
2017-08-15 05:00:00	SPY	ETF	246.91	246.92	246.91	246.92	400.0
2017-08-15 05:30:00	SPY	ETF	246.93	246.93	246.92	246.92	600.0
2017-08-15 06:00:00	SPY	ETF	246.92	247.04	246.86	246.86	4700.0
2017-08-15 06:30:00	SPY	ETF	246.84	247.05	246.84	247.05	6305.0
2017-08-15 07:00:00	SPY	ETF	247.06	247.19	247.06	247.12	35995.0
2017-08-15 07:30:00	SPY	ETF	247.12	247.15	247.03	247.05	33686.0
2017-08-15 08:00:00	SPY	ETF	247.11	247.12	246.95	246.95	366185.0
2017-08-15 08:30:00	SPY	ETF	247.02	247.2	246.88	247.05	202161.0
2017-08-15 09:00:00	SPY	ETF	247.06	247.15	246.98	246.98	316423.0
2017-08-15 09:30:00	SPY	ETF	246.98	247.0	246.41	246.76	5607957.0
2017-08-15 10:00:00	SPY	ETF	246.755	246.81	246.22	246.43	7939990.0
2017-08-15 10:30:00	SPY	ETF	246.44	246.59	246.16	246.4201	2314099.0
2017-08-15 11:00:00	SPY	ETF	246.43	246.66	246.37	246.6	1813685.0
2017-08-15 11:30:00	SPY	ETF	246.61	246.66	246.36	246.375	1668284.0
2017-08-15 12:00:00	SPY	ETF	246.375	246.63	246.36	246.61	3100725.0
2017-08-15 12:30:00	SPY	ETF	246.61	246.65	246.52	246.52	991138.0
2017-08-15 13:00:00	SPY	ETF	246.525	246.53	246.21	246.385	1928395.0
2017-08-15 13:30:00	SPY	ETF	246.39	246.4999	246.305	246.38	1596925.0
2017-08-15 14:00:00	SPY	ETF	246.3851	246.7	246.38	246.68	2368088.0
2017-08-15 14:30:00	SPY	ETF	246.675	246.71	246.53	246.641	2691462.0
2017-08-15 15:00:00	SPY	ETF	246.64	246.85	246.62	246.72	4218496.0
2017-08-15 15:30:00	SPY	ETF	246.73	246.92	246.46	246.53	9624740.0
2017-08-15 16:00:00	SPY	ETF	246.51	246.75	246.48	246.59	6523451.0
2017-08-15 16:30:00	SPY	ETF	246.62	246.6608	246.51	246.59	999368.0
2017-08-15 17:00:00	SPY	ETF	246.61	246.63	246.3364	246.61	105733.0
2017-08-15 17:30:00	SPY	ETF	246.62	246.62	246.56	246.61	74529.0
2017-08-15 18:00:00	SPY	ETF	246.62	246.67	246.34	246.39	79352.0
2017-08-15 18:30:00	SPY	ETF	246.39	246.46	246.39	246.44	24044.0
2017-08-15 19:00:00	SPY	ETF	246.41	246.41	246.34	246.38	13442.0
2017-08-15 19:30:00	SPY	ETF	246.39	246.43	246.39	246.4	9213.0
2017-08-15 04:00:00	QQQ	ETF	144.15	144.35	144.15	144.35	1300.0
2017-08-15 04:30:00	QQQ	ETF	144.33	144.36	144.33	144.36	1000.0
2017-08-15 05:30:00	QQQ	ETF	144.29	144.4	144.29	144.34	15384.0
2017-08-15 06:00:00	QQQ	ETF	144.32	144.36	144.27	144.27	11400.0
2017-08-15 06:30:00	QQQ	ETF	144.27	144.36	144.27	144.35	2778.0
2017-08-15 07:00:00	QQQ	ETF	144.41	144.45	144.39	144.41	5877.0
2017-08-15 07:30:00	QQQ	ETF	144.44	144.44	144.37	144.42	11530.0
2017-08-15 08:00:00	QQQ	ETF	144.45	144.45	144.35	144.37	31226.0
2017-08-15 08:30:00	QQQ	ETF	144.41	144.48	144.18	144.3	64914.0
2017-08-15 09:00:00	QQQ	ETF	144.28	144.33	144.2	144.22	98921.0
2017-08-15 09:30:00	QQQ	ETF	144.22	144.302	143.72	144.01	3686775.0
2017-08-15 10:00:00	QQQ	ETF	144.0117	144.09	143.64	143.9	1712988.0
2017-08-15 10:30:00	QQQ	ETF	143.91	144.07	143.66	143.89	1472213.0
2017-08-15 11:00:00	QQQ	ETF	143.885	144.06	143.82	144.06	1212031.0
2017-08-15 11:30:00	QQQ	ETF	144.05	144.16	143.83	143.86	1407664.0
2017-08-15 12:00:00	QQQ	ETF	143.86	144.11	143.84	144.1	845844.0
2017-08-15 12:30:00	QQQ	ETF	144.101	144.22	144.05	144.13	840174.0
2017-08-15 13:00:00	QQQ	ETF	144.13	144.135	143.8699	143.98	1252710.0
2017-08-15 13:30:00	QQQ	ETF	143.97	144.035	143.85	143.92	679724.0

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

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