PREVIEW / etf_30min / 2018-02-20

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-02-20.parquet
  size:    486 KB
  rows:    16,839

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
2018-02-20 04:00:00	SPY	ETF	272.54	272.58	271.92	271.97	14321.0
2018-02-20 04:30:00	SPY	ETF	271.95	271.95	271.18	271.23	32384.0
2018-02-20 05:00:00	SPY	ETF	271.26	271.34	270.86	271.34	22781.0
2018-02-20 05:30:00	SPY	ETF	271.44	271.7	271.32	271.7	13308.0
2018-02-20 06:00:00	SPY	ETF	271.66	271.66	271.1	271.17	41162.0
2018-02-20 06:30:00	SPY	ETF	271.2	271.6	271.11	271.51	16642.0
2018-02-20 07:00:00	SPY	ETF	271.58	271.89	271.51	271.6	86821.0
2018-02-20 07:30:00	SPY	ETF	271.66	271.92	271.6	271.86	132494.0
2018-02-20 08:00:00	SPY	ETF	271.86	272.81	271.32	271.73	275433.0
2018-02-20 08:30:00	SPY	ETF	271.75	272.11	271.71	271.75	252397.0
2018-02-20 09:00:00	SPY	ETF	271.76	272.09	271.3	271.99	979552.0
2018-02-20 09:30:00	SPY	ETF	272.03	273.1075	271.97	272.24	6877188.0
2018-02-20 10:00:00	SPY	ETF	272.25	272.76	272.05	272.28	5677469.0
2018-02-20 10:30:00	SPY	ETF	272.27	272.36	271.68	271.9	4771935.0
2018-02-20 11:00:00	SPY	ETF	271.89	273.26	271.8	273.2102	7801963.0
2018-02-20 11:30:00	SPY	ETF	273.22	273.54	272.89	273.475	6455916.0
2018-02-20 12:00:00	SPY	ETF	273.48	273.67	273.245	273.35	1803753.0
2018-02-20 12:30:00	SPY	ETF	273.34	273.58	273.13	273.405	1742611.0
2018-02-20 13:00:00	SPY	ETF	273.4	273.4638	272.42	272.555	2693620.0
2018-02-20 13:30:00	SPY	ETF	272.57	273.14	272.4107	273.02	2478171.0
2018-02-20 14:00:00	SPY	ETF	273.0182	273.1	272.1	272.21	3451248.0
2018-02-20 14:30:00	SPY	ETF	272.2	272.66	271.67	271.74	3154983.0
2018-02-20 15:00:00	SPY	ETF	271.74	272.04	270.5	271.12	8179450.0
2018-02-20 15:30:00	SPY	ETF	271.12	271.92	270.835	271.43	13662147.0
2018-02-20 16:00:00	SPY	ETF	271.44	271.52	271.13	271.38	7590979.0
2018-02-20 16:30:00	SPY	ETF	271.41	271.57	271.39	271.4357	906040.0
2018-02-20 17:00:00	SPY	ETF	271.47	271.63	271.4	271.54	958904.0
2018-02-20 17:30:00	SPY	ETF	271.5	271.52	271.38	271.38	838633.0
2018-02-20 18:00:00	SPY	ETF	271.42	271.58	271.18	271.53	226830.0
2018-02-20 18:30:00	SPY	ETF	271.54	271.83	271.4	271.8	574863.0
2018-02-20 19:00:00	SPY	ETF	271.76	271.87	271.63	271.75	17626.0
2018-02-20 19:30:00	SPY	ETF	271.78	272.02	271.78	271.98	80340.0
2018-02-20 04:00:00	QQQ	ETF	164.96	164.96	164.48	164.48	17373.0
2018-02-20 04:30:00	QQQ	ETF	164.42	164.45	163.99	164.08	12315.0
2018-02-20 05:00:00	QQQ	ETF	164.04	164.08	163.79	163.96	21816.0
2018-02-20 05:30:00	QQQ	ETF	164.0	164.16	163.96	164.13	17725.0
2018-02-20 06:00:00	QQQ	ETF	164.07	164.11	163.88	163.9	9524.0
2018-02-20 06:30:00	QQQ	ETF	163.98	164.1	163.92	164.02	68922.0
2018-02-20 07:00:00	QQQ	ETF	164.14	164.27	164.08	164.14	60022.0
2018-02-20 07:30:00	QQQ	ETF	164.17	164.33	164.16	164.28	31407.0
2018-02-20 08:00:00	QQQ	ETF	164.11	164.99	164.08	164.26	90989.0
2018-02-20 08:30:00	QQQ	ETF	164.25	164.49	164.25	164.33	217785.0
2018-02-20 09:00:00	QQQ	ETF	164.36	164.46	164.22	164.36	277211.0
2018-02-20 09:30:00	QQQ	ETF	164.37	165.59	164.31	165.18	3787777.0
2018-02-20 10:00:00	QQQ	ETF	165.18	165.905	165.0955	165.57	2257902.0
2018-02-20 10:30:00	QQQ	ETF	165.55	165.72	165.19	165.47	1756569.0
2018-02-20 11:00:00	QQQ	ETF	165.4599	166.37	165.4	166.34	1638095.0
2018-02-20 11:30:00	QQQ	ETF	166.34	166.58	166.12	166.54	1500030.0
2018-02-20 12:00:00	QQQ	ETF	166.54	166.669	166.41	166.49	1170639.0
2018-02-20 12:30:00	QQQ	ETF	166.48	166.68	166.36	166.6	887941.0

> showing 50 of 16,839 rows — these rows as CSV

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