PREVIEW / etf_30min / 2018-03-22

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-03-22.parquet
  size:    488 KB
  rows:    16,960

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-22 04:00:00	SPY	ETF	268.99	269.46	268.84	269.46	14545.0
2018-03-22 04:30:00	SPY	ETF	269.6	269.68	269.49	269.63	3465.0
2018-03-22 05:00:00	SPY	ETF	269.55	269.56	268.58	268.66	69262.0
2018-03-22 05:30:00	SPY	ETF	268.73	268.94	268.58	268.83	45940.0
2018-03-22 06:00:00	SPY	ETF	268.91	269.24	268.88	269.05	40398.0
2018-03-22 06:30:00	SPY	ETF	269.07	269.18	268.56	268.9	69303.0
2018-03-22 07:00:00	SPY	ETF	268.95	269.17	268.84	268.87	206685.0
2018-03-22 07:30:00	SPY	ETF	268.9	269.25	268.72	268.76	377456.0
2018-03-22 08:00:00	SPY	ETF	268.95	270.64	268.75	268.9	263516.0
2018-03-22 08:30:00	SPY	ETF	268.91	269.07	267.7	268.05	800443.0
2018-03-22 09:00:00	SPY	ETF	268.05	268.08	267.54	267.9	808637.0
2018-03-22 09:30:00	SPY	ETF	267.91	268.39	267.16	267.68	9330426.0
2018-03-22 10:00:00	SPY	ETF	267.68	268.87	267.47	268.07	7727507.0
2018-03-22 10:30:00	SPY	ETF	268.06	268.08	266.33	266.73	7420752.0
2018-03-22 11:00:00	SPY	ETF	266.72	267.08	266.03	266.2859	7972342.0
2018-03-22 11:30:00	SPY	ETF	266.32	266.52	265.4	265.8	8482725.0
2018-03-22 12:00:00	SPY	ETF	265.8	267.55	265.48	267.43	10887567.0
2018-03-22 12:30:00	SPY	ETF	267.44	267.79	266.77	266.915	7916912.0
2018-03-22 13:00:00	SPY	ETF	266.91	267.93	266.2	267.8786	6394154.0
2018-03-22 13:30:00	SPY	ETF	267.88	268.23	267.525	267.82	6153986.0
2018-03-22 14:00:00	SPY	ETF	267.8	267.9699	266.33	266.33	6051706.0
2018-03-22 14:30:00	SPY	ETF	266.33	266.889	265.72	265.8699	7530242.0
2018-03-22 15:00:00	SPY	ETF	265.865	266.47	264.93	265.14	10392477.0
2018-03-22 15:30:00	SPY	ETF	265.14	265.26	263.36	263.67	28274153.0
2018-03-22 16:00:00	SPY	ETF	263.7	264.25	263.32	263.4	14825200.0
2018-03-22 16:30:00	SPY	ETF	263.41	270.4428	263.35	263.8	1432318.0
2018-03-22 17:00:00	SPY	ETF	263.74	264.1	263.67	263.82	1271237.0
2018-03-22 17:30:00	SPY	ETF	263.89	263.97	263.52	263.67	213903.0
2018-03-22 18:00:00	SPY	ETF	263.69	263.8	262.75	262.91	270627.0
2018-03-22 18:30:00	SPY	ETF	262.97	263.16	262.59	263.02	233952.0
2018-03-22 19:00:00	SPY	ETF	263.04	263.08	262.43	262.48	131449.0
2018-03-22 19:30:00	SPY	ETF	262.47	262.48	261.89	262.0	246621.0
2018-03-22 04:00:00	QQQ	ETF	165.67	166.27	165.58	166.18	50416.0
2018-03-22 04:30:00	QQQ	ETF	166.03	166.15	165.88	166.0	22147.0
2018-03-22 05:00:00	QQQ	ETF	166.0	166.0	165.23	165.31	103179.0
2018-03-22 05:30:00	QQQ	ETF	165.24	165.46	165.14	165.33	33474.0
2018-03-22 06:00:00	QQQ	ETF	165.33	165.57	165.33	165.49	42711.0
2018-03-22 06:30:00	QQQ	ETF	165.5	165.53	164.93	165.21	51199.0
2018-03-22 07:00:00	QQQ	ETF	165.22	165.49	165.22	165.35	110210.0
2018-03-22 07:30:00	QQQ	ETF	165.33	165.61	165.26	165.27	129194.0
2018-03-22 08:00:00	QQQ	ETF	165.27	165.63	165.26	165.46	146164.0
2018-03-22 08:30:00	QQQ	ETF	165.44	165.61	164.68	164.93	375379.0
2018-03-22 09:00:00	QQQ	ETF	164.94	164.95	164.39	164.7	603735.0
2018-03-22 09:30:00	QQQ	ETF	164.7	165.48	164.36	165.04	5612565.0
2018-03-22 10:00:00	QQQ	ETF	165.02	165.77	164.78	165.19	3625179.0
2018-03-22 10:30:00	QQQ	ETF	165.18	165.18	163.85	164.165	2720273.0
2018-03-22 11:00:00	QQQ	ETF	164.1607	164.48	163.6	163.82	3193404.0
2018-03-22 11:30:00	QQQ	ETF	163.8399	163.92	163.13	163.55	3212948.0
2018-03-22 12:00:00	QQQ	ETF	163.55	164.62	163.29	164.53	5704301.0
2018-03-22 12:30:00	QQQ	ETF	164.53	164.8266	164.24	164.4	2733883.0

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

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