PREVIEW / etf_30min / 2018-04-13

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-13.parquet
  size:    447 KB
  rows:    15,398

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-04-13 04:00:00	SPY	ETF	266.12	266.12	265.96	266.05	13507.0
2018-04-13 04:30:00	SPY	ETF	266.08	266.2	265.99	266.2	3875.0
2018-04-13 05:00:00	SPY	ETF	266.2	266.22	266.16	266.16	4704.0
2018-04-13 05:30:00	SPY	ETF	266.16	266.5	266.14	266.5	18450.0
2018-04-13 06:00:00	SPY	ETF	266.51	266.58	266.35	266.42	107670.0
2018-04-13 06:30:00	SPY	ETF	266.3	266.76	266.25	266.68	132218.0
2018-04-13 07:00:00	SPY	ETF	266.66	266.83	266.43	266.47	76811.0
2018-04-13 07:30:00	SPY	ETF	266.5	266.8	266.42	266.72	109348.0
2018-04-13 08:00:00	SPY	ETF	266.72	267.21	265.22	267.2	275453.0
2018-04-13 08:30:00	SPY	ETF	267.2	267.49	267.2	267.35	383733.0
2018-04-13 09:00:00	SPY	ETF	267.36	267.52	267.25	267.41	645434.0
2018-04-13 09:30:00	SPY	ETF	267.41	267.54	266.51	266.575	6526246.0
2018-04-13 10:00:00	SPY	ETF	266.56	266.75	265.1864	265.41	7443273.0
2018-04-13 10:30:00	SPY	ETF	265.38	265.84	265.03	265.04	5986763.0
2018-04-13 11:00:00	SPY	ETF	265.06	265.82	264.63	265.7	5301925.0
2018-04-13 11:30:00	SPY	ETF	265.7	265.9	265.27	265.81	3315496.0
2018-04-13 12:00:00	SPY	ETF	265.8	266.087	265.34	265.96	3174180.0
2018-04-13 12:30:00	SPY	ETF	265.96	265.98	265.27	265.59	3354157.0
2018-04-13 13:00:00	SPY	ETF	265.6	266.33	265.59	266.27	3269988.0
2018-04-13 13:30:00	SPY	ETF	266.27	266.31	265.92	266.0662	3882577.0
2018-04-13 14:00:00	SPY	ETF	266.06	266.19	265.59	265.79	3108949.0
2018-04-13 14:30:00	SPY	ETF	265.78	266.1	265.25	265.34	4901291.0
2018-04-13 15:00:00	SPY	ETF	265.34	265.34	264.01	264.37	9732291.0
2018-04-13 15:30:00	SPY	ETF	264.34	265.415	264.14	265.16	12655224.0
2018-04-13 16:00:00	SPY	ETF	265.15	265.33	265.01	265.14	7352729.0
2018-04-13 16:30:00	SPY	ETF	265.13	265.4	265.09	265.4	532844.0
2018-04-13 17:00:00	SPY	ETF	265.29	265.37	265.15	265.25	179731.0
2018-04-13 17:30:00	SPY	ETF	265.28	265.6	265.15	265.43	74986.0
2018-04-13 18:00:00	SPY	ETF	265.41	265.48	263.69	265.16	91280.0
2018-04-13 18:30:00	SPY	ETF	265.2	265.24	265.13	265.15	8961.0
2018-04-13 19:00:00	SPY	ETF	265.16	265.26	265.12	265.15	11835.0
2018-04-13 19:30:00	SPY	ETF	265.29	265.38	265.19	265.33	15423.0
2018-04-13 04:00:00	QQQ	ETF	162.0	162.0	161.92	161.99	7700.0
2018-04-13 04:30:00	QQQ	ETF	162.04	162.04	161.92	161.97	1500.0
2018-04-13 05:00:00	QQQ	ETF	162.05	162.05	162.0	162.0	661.0
2018-04-13 05:30:00	QQQ	ETF	162.0	162.21	162.0	162.21	2000.0
2018-04-13 06:00:00	QQQ	ETF	162.29	162.29	162.12	162.21	9922.0
2018-04-13 06:30:00	QQQ	ETF	162.2	162.46	162.2	162.46	2480.0
2018-04-13 07:00:00	QQQ	ETF	162.5	162.5	162.31	162.35	18225.0
2018-04-13 07:30:00	QQQ	ETF	162.39	162.54	162.3	162.52	35218.0
2018-04-13 08:00:00	QQQ	ETF	162.36	162.93	162.3	162.93	85239.0
2018-04-13 08:30:00	QQQ	ETF	162.9	163.1	162.9	163.01	317081.0
2018-04-13 09:00:00	QQQ	ETF	163.03	163.12	162.93	163.01	97645.0
2018-04-13 09:30:00	QQQ	ETF	163.01	163.26	162.34	162.45	3530846.0
2018-04-13 10:00:00	QQQ	ETF	162.44	162.57	161.35	161.48	3718141.0
2018-04-13 10:30:00	QQQ	ETF	161.49	162.06	161.221	161.54	2729744.0
2018-04-13 11:00:00	QQQ	ETF	161.55	161.9452	161.13	161.8682	2029484.0
2018-04-13 11:30:00	QQQ	ETF	161.87	162.04	161.42	161.879	2104627.0
2018-04-13 12:00:00	QQQ	ETF	161.87	162.09	161.55	162.02	1516446.0
2018-04-13 12:30:00	QQQ	ETF	162.01	162.02	161.6108	161.94	1126247.0

> showing 50 of 15,398 rows — these rows as CSV

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