PREVIEW / etf_30min / 2018-02-05

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-02-05.parquet
  size:    544 KB
  rows:    19,140

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-05 04:00:00	SPY	ETF	274.56	274.81	274.48	274.64	51615.0
2018-02-05 04:30:00	SPY	ETF	274.69	275.1	274.69	275.07	10795.0
2018-02-05 05:00:00	SPY	ETF	274.88	275.0	274.47	274.47	22524.0
2018-02-05 05:30:00	SPY	ETF	274.65	274.65	274.38	274.38	22936.0
2018-02-05 06:00:00	SPY	ETF	274.49	274.49	274.08	274.24	32094.0
2018-02-05 06:30:00	SPY	ETF	274.24	274.29	273.75	273.79	104054.0
2018-02-05 07:00:00	SPY	ETF	273.82	273.82	273.04	273.54	352365.0
2018-02-05 07:30:00	SPY	ETF	273.57	273.93	273.21	273.91	505627.0
2018-02-05 08:00:00	SPY	ETF	273.86	274.6	273.11	274.2	1120432.0
2018-02-05 08:30:00	SPY	ETF	274.2	274.55	274.12	274.19	890276.0
2018-02-05 09:00:00	SPY	ETF	274.19	274.26	273.36	273.46	976040.0
2018-02-05 09:30:00	SPY	ETF	273.45	274.2	272.96	274.0	18079866.0
2018-02-05 10:00:00	SPY	ETF	274.0	275.85	273.62	275.6834	13873062.0
2018-02-05 10:30:00	SPY	ETF	275.68	275.805	274.91	275.39	8897750.0
2018-02-05 11:00:00	SPY	ETF	275.4	275.76	274.73	274.89	6940824.0
2018-02-05 11:30:00	SPY	ETF	274.9	274.9	274.01	274.5	6911324.0
2018-02-05 12:00:00	SPY	ETF	274.505	274.56	272.82	273.3	8014253.0
2018-02-05 12:30:00	SPY	ETF	273.3	273.9	273.185	273.19	5672662.0
2018-02-05 13:00:00	SPY	ETF	273.18	273.19	271.13	271.52	16437176.0
2018-02-05 13:30:00	SPY	ETF	271.52	272.74	271.1	272.64	19311417.0
2018-02-05 14:00:00	SPY	ETF	272.65	272.71	270.73	270.92	13906990.0
2018-02-05 14:30:00	SPY	ETF	270.91	270.91	268.4	268.54	29196825.0
2018-02-05 15:00:00	SPY	ETF	268.55	269.41	263.31	269.11	47061030.0
2018-02-05 15:30:00	SPY	ETF	269.11	269.38	264.0	264.18	56387123.0
2018-02-05 16:00:00	SPY	ETF	264.2	265.58	260.0	260.59	25798748.0
2018-02-05 16:30:00	SPY	ETF	260.56	273.4	259.35	261.31	4657259.0
2018-02-05 17:00:00	SPY	ETF	261.4	267.08	260.4	260.65	774942.0
2018-02-05 17:30:00	SPY	ETF	260.61	263.93	260.61	261.64	425602.0
2018-02-05 18:00:00	SPY	ETF	261.64	270.4263	260.91	262.35	943880.0
2018-02-05 18:30:00	SPY	ETF	262.35	262.57	260.12	261.44	403622.0
2018-02-05 19:00:00	SPY	ETF	261.43	263.93	260.91	262.56	443930.0
2018-02-05 19:30:00	SPY	ETF	262.58	273.44	260.66	261.1	188211.0
2018-02-05 04:00:00	QQQ	ETF	164.12	164.34	164.12	164.16	38389.0
2018-02-05 04:30:00	QQQ	ETF	164.18	164.37	164.15	164.32	18032.0
2018-02-05 05:00:00	QQQ	ETF	164.31	164.39	164.21	164.21	10756.0
2018-02-05 05:30:00	QQQ	ETF	164.34	164.4	164.2	164.24	20660.0
2018-02-05 06:00:00	QQQ	ETF	164.06	164.06	163.84	163.99	12179.0
2018-02-05 06:30:00	QQQ	ETF	164.01	164.05	163.58	163.58	37398.0
2018-02-05 07:00:00	QQQ	ETF	163.6	163.6	162.8	163.06	410448.0
2018-02-05 07:30:00	QQQ	ETF	163.09	163.3	162.68	163.14	435991.0
2018-02-05 08:00:00	QQQ	ETF	163.11	164.42	162.77	163.36	238070.0
2018-02-05 08:30:00	QQQ	ETF	163.44	163.85	163.43	163.65	339097.0
2018-02-05 09:00:00	QQQ	ETF	163.58	163.65	162.96	163.16	640544.0
2018-02-05 09:30:00	QQQ	ETF	163.15	164.1001	162.53	164.1001	8749736.0
2018-02-05 10:00:00	QQQ	ETF	164.1	165.75	163.74	165.49	6488155.0
2018-02-05 10:30:00	QQQ	ETF	165.515	165.63	164.92	165.0383	3493655.0
2018-02-05 11:00:00	QQQ	ETF	165.04	165.36	164.49	164.65	2452003.0
2018-02-05 11:30:00	QQQ	ETF	164.63	164.64	164.01	164.4499	2722894.0
2018-02-05 12:00:00	QQQ	ETF	164.44	164.49	163.43	163.7937	3136316.0
2018-02-05 12:30:00	QQQ	ETF	163.8	164.34	163.705	163.92	2293232.0

> showing 50 of 19,140 rows — these rows as CSV

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