PREVIEW / etf_30min / 2018-06-22

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-06-22.parquet
  size:    455 KB
  rows:    15,851

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-06-22 04:00:00	SPY	ETF	275.07	275.35	275.07	275.35	29804.0
2018-06-22 04:30:00	SPY	ETF	275.34	275.55	275.29	275.48	29594.0
2018-06-22 05:00:00	SPY	ETF	275.49	275.59	275.48	275.51	24091.0
2018-06-22 05:30:00	SPY	ETF	275.61	275.61	275.38	275.38	11574.0
2018-06-22 06:00:00	SPY	ETF	275.31	275.43	275.3	275.43	13091.0
2018-06-22 06:30:00	SPY	ETF	275.43	275.51	275.4	275.44	17452.0
2018-06-22 07:00:00	SPY	ETF	275.44	275.52	275.28	275.39	172010.0
2018-06-22 07:30:00	SPY	ETF	275.36	275.58	275.34	275.58	81985.0
2018-06-22 08:00:00	SPY	ETF	275.56	275.75	274.81	275.62	357829.0
2018-06-22 08:30:00	SPY	ETF	275.6	275.65	274.24	275.6	155772.0
2018-06-22 09:00:00	SPY	ETF	275.6	275.75	275.59	275.66	309359.0
2018-06-22 09:30:00	SPY	ETF	275.66	275.785	274.99	275.18	5703628.0
2018-06-22 10:00:00	SPY	ETF	275.175	275.61	274.79	274.92	4500432.0
2018-06-22 10:30:00	SPY	ETF	274.92	275.24	274.68	275.21	4780010.0
2018-06-22 11:00:00	SPY	ETF	275.21	275.35	274.92	275.28	2463032.0
2018-06-22 11:30:00	SPY	ETF	275.279	275.52	275.18	275.3185	2104819.0
2018-06-22 12:00:00	SPY	ETF	275.32	275.61	275.27	275.35	1571401.0
2018-06-22 12:30:00	SPY	ETF	275.35	275.43	275.21	275.35	1156949.0
2018-06-22 13:00:00	SPY	ETF	275.36	275.51	275.34	275.5	1226832.0
2018-06-22 13:30:00	SPY	ETF	275.5	275.64	275.37	275.5473	1987529.0
2018-06-22 14:00:00	SPY	ETF	275.55	275.68	275.24	275.27	1815569.0
2018-06-22 14:30:00	SPY	ETF	275.265	275.57	275.155	275.48	2251136.0
2018-06-22 15:00:00	SPY	ETF	275.48	275.505	275.23	275.32	2633842.0
2018-06-22 15:30:00	SPY	ETF	275.32	275.43	274.49	274.71	10315526.0
2018-06-22 16:00:00	SPY	ETF	274.71	275.13	274.71	274.74	8650860.0
2018-06-22 16:30:00	SPY	ETF	274.92	274.94	274.65	274.67	686494.0
2018-06-22 17:00:00	SPY	ETF	274.67	274.8	274.58	274.59	952592.0
2018-06-22 17:30:00	SPY	ETF	274.59	274.63	274.45	274.45	58603.0
2018-06-22 18:00:00	SPY	ETF	274.49	274.56	274.46	274.56	30876.0
2018-06-22 18:30:00	SPY	ETF	274.57	274.62	274.54	274.54	8278.0
2018-06-22 19:00:00	SPY	ETF	274.54	274.61	274.52	274.52	4545.0
2018-06-22 19:30:00	SPY	ETF	274.54	274.58	274.5	274.5	17200.0
2018-06-22 04:00:00	QQQ	ETF	176.0	176.13	175.72	176.05	2520.0
2018-06-22 04:30:00	QQQ	ETF	176.16	176.29	176.16	176.26	2603.0
2018-06-22 05:00:00	QQQ	ETF	176.29	176.32	176.24	176.32	2200.0
2018-06-22 05:30:00	QQQ	ETF	176.41	176.41	176.28	176.28	19500.0
2018-06-22 06:00:00	QQQ	ETF	176.21	176.3	176.19	176.3	7300.0
2018-06-22 06:30:00	QQQ	ETF	176.25	176.33	176.25	176.3	10100.0
2018-06-22 07:00:00	QQQ	ETF	176.27	176.32	176.14	176.22	33012.0
2018-06-22 07:30:00	QQQ	ETF	176.2	176.31	176.15	176.31	48710.0
2018-06-22 08:00:00	QQQ	ETF	176.15	176.5	176.15	176.41	121004.0
2018-06-22 08:30:00	QQQ	ETF	176.4	176.43	176.31	176.35	62202.0
2018-06-22 09:00:00	QQQ	ETF	176.35	176.38	176.32	176.33	62169.0
2018-06-22 09:30:00	QQQ	ETF	176.31	176.369	175.07	175.21	4209990.0
2018-06-22 10:00:00	QQQ	ETF	175.205	175.6	174.73	174.84	3012464.0
2018-06-22 10:30:00	QQQ	ETF	174.84	175.24	174.69	175.22	2785884.0
2018-06-22 11:00:00	QQQ	ETF	175.22	175.39	175.045	175.37	1203356.0
2018-06-22 11:30:00	QQQ	ETF	175.37	175.5854	175.27	175.42	935609.0
2018-06-22 12:00:00	QQQ	ETF	175.425	175.715	175.37	175.51	671239.0
2018-06-22 12:30:00	QQQ	ETF	175.51	175.665	175.38	175.5949	822351.0

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

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