PREVIEW / etf_30min / 2018-03-02

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-03-02.parquet
  size:    483 KB
  rows:    16,473

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-03-02 04:00:00	SPY	ETF	267.79	267.79	267.22	267.39	17394.0
2018-03-02 04:30:00	SPY	ETF	267.33	267.37	267.0	267.04	25432.0
2018-03-02 05:00:00	SPY	ETF	267.08	267.23	266.87	267.19	43756.0
2018-03-02 05:30:00	SPY	ETF	267.22	267.43	266.48	266.61	83003.0
2018-03-02 06:00:00	SPY	ETF	266.46	266.69	266.14	266.27	68034.0
2018-03-02 06:30:00	SPY	ETF	266.13	266.84	266.02	266.67	78736.0
2018-03-02 07:00:00	SPY	ETF	266.68	266.9	266.39	266.76	136045.0
2018-03-02 07:30:00	SPY	ETF	266.73	266.85	265.7	265.8	479740.0
2018-03-02 08:00:00	SPY	ETF	267.24	268.32	265.42	265.76	910013.0
2018-03-02 08:30:00	SPY	ETF	265.82	267.7	265.7	266.32	678860.0
2018-03-02 09:00:00	SPY	ETF	266.33	266.44	265.43	265.8	731925.0
2018-03-02 09:30:00	SPY	ETF	265.8	266.59	264.82	265.57	16541524.0
2018-03-02 10:00:00	SPY	ETF	265.58	266.12	264.93	265.5	8154058.0
2018-03-02 10:30:00	SPY	ETF	265.49	266.859	265.3	265.97	8603348.0
2018-03-02 11:00:00	SPY	ETF	265.97	266.8	265.4514	266.63	5734103.0
2018-03-02 11:30:00	SPY	ETF	266.63	267.88	266.15	267.84	9046497.0
2018-03-02 12:00:00	SPY	ETF	267.84	268.05	267.1	267.97	5833025.0
2018-03-02 12:30:00	SPY	ETF	267.96	268.66	267.43	268.41	5660352.0
2018-03-02 13:00:00	SPY	ETF	268.41	268.48	267.14	267.145	6804657.0
2018-03-02 13:30:00	SPY	ETF	267.14	267.7	266.53	267.21	6316224.0
2018-03-02 14:00:00	SPY	ETF	267.22	268.26	267.22	267.66	4759011.0
2018-03-02 14:30:00	SPY	ETF	267.66	268.43	267.29	267.735	6889355.0
2018-03-02 15:00:00	SPY	ETF	267.73	268.17	267.08	268.05	6276439.0
2018-03-02 15:30:00	SPY	ETF	268.04	269.72	267.97	269.13	19112871.0
2018-03-02 16:00:00	SPY	ETF	269.15	269.24	267.8553	269.15	18212827.0
2018-03-02 16:30:00	SPY	ETF	269.18	269.45	269.01	269.13	2451084.0
2018-03-02 17:00:00	SPY	ETF	269.11	269.22	269.04	269.2	101222.0
2018-03-02 17:30:00	SPY	ETF	269.23	269.4	269.16	269.37	61884.0
2018-03-02 18:00:00	SPY	ETF	269.39	269.44	269.33	269.4	16131.0
2018-03-02 18:30:00	SPY	ETF	269.38	269.45	269.35	269.35	14312.0
2018-03-02 19:00:00	SPY	ETF	269.39	269.47	269.36	269.38	17134.0
2018-03-02 19:30:00	SPY	ETF	269.37	269.38	269.3	269.32	18742.0
2018-03-02 04:00:00	QQQ	ETF	164.59	164.59	164.27	164.33	52091.0
2018-03-02 04:30:00	QQQ	ETF	164.26	164.37	164.12	164.18	32147.0
2018-03-02 05:00:00	QQQ	ETF	164.17	164.19	163.95	164.16	23239.0
2018-03-02 05:30:00	QQQ	ETF	164.36	164.36	163.73	163.79	77894.0
2018-03-02 06:00:00	QQQ	ETF	163.69	163.72	163.22	163.22	83892.0
2018-03-02 06:30:00	QQQ	ETF	163.21	164.45	163.08	163.42	75504.0
2018-03-02 07:00:00	QQQ	ETF	163.44	163.75	163.21	163.52	191456.0
2018-03-02 07:30:00	QQQ	ETF	163.56	163.6	162.71	162.77	511178.0
2018-03-02 08:00:00	QQQ	ETF	162.79	163.69	162.54	162.73	274220.0
2018-03-02 08:30:00	QQQ	ETF	162.73	163.22	162.68	163.07	451435.0
2018-03-02 09:00:00	QQQ	ETF	163.02	163.08	162.42	162.62	414251.0
2018-03-02 09:30:00	QQQ	ETF	162.62	163.37	161.96	162.92	7937299.0
2018-03-02 10:00:00	QQQ	ETF	162.93	163.2686	162.48	162.96	3426952.0
2018-03-02 10:30:00	QQQ	ETF	162.979	163.96	162.79	163.3459	3857607.0
2018-03-02 11:00:00	QQQ	ETF	163.34	164.12	163.09	164.075	3526014.0
2018-03-02 11:30:00	QQQ	ETF	164.075	164.75	163.6352	164.74	3634381.0
2018-03-02 12:00:00	QQQ	ETF	164.74	165.12	164.33	164.88	2305680.0
2018-03-02 12:30:00	QQQ	ETF	164.88	165.3	164.4082	165.13	2014772.0

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

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