PREVIEW / etf_30min / 2018-10-26

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-26.parquet
  size:    509 KB
  rows:    17,834

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-10-26 04:00:00	SPY	ETF	266.0	266.22	265.66	265.86	49150.0
2018-10-26 04:30:00	SPY	ETF	265.79	266.05	265.33	265.66	31828.0
2018-10-26 05:00:00	SPY	ETF	265.59	265.59	264.35	264.36	111608.0
2018-10-26 05:30:00	SPY	ETF	264.4	264.91	264.1	264.68	261354.0
2018-10-26 06:00:00	SPY	ETF	264.68	265.19	264.51	264.98	156992.0
2018-10-26 06:30:00	SPY	ETF	265.05	265.28	264.76	264.94	127289.0
2018-10-26 07:00:00	SPY	ETF	264.99	265.76	264.99	265.72	407218.0
2018-10-26 07:30:00	SPY	ETF	265.75	265.8	265.0	265.22	227444.0
2018-10-26 08:00:00	SPY	ETF	265.22	267.07	264.75	265.08	901510.0
2018-10-26 08:30:00	SPY	ETF	265.07	266.29	265.05	266.25	1424097.0
2018-10-26 09:00:00	SPY	ETF	266.22	266.28	265.56	265.9	839285.0
2018-10-26 09:30:00	SPY	ETF	265.92	271.0	265.1	265.81	15488605.0
2018-10-26 10:00:00	SPY	ETF	265.8	265.81	263.37	264.41	15928158.0
2018-10-26 10:30:00	SPY	ETF	264.4	264.41	262.29	262.48	13885569.0
2018-10-26 11:00:00	SPY	ETF	262.44	265.33	262.32	265.05	11935904.0
2018-10-26 11:30:00	SPY	ETF	265.07	266.19	264.72	265.31	10854659.0
2018-10-26 12:00:00	SPY	ETF	265.31	266.92	265.22	266.62	9969467.0
2018-10-26 12:30:00	SPY	ETF	266.63	268.32	266.38	267.56	8987436.0
2018-10-26 13:00:00	SPY	ETF	267.55	268.78	267.13	267.17	8426120.0
2018-10-26 13:30:00	SPY	ETF	267.16	267.62	265.95	267.29	8387931.0
2018-10-26 14:00:00	SPY	ETF	267.3	267.59	265.51	266.32	9456101.0
2018-10-26 14:30:00	SPY	ETF	266.32	267.03	264.13	264.47	10916895.0
2018-10-26 15:00:00	SPY	ETF	264.46	265.86	263.6601	265.24	17889402.0
2018-10-26 15:30:00	SPY	ETF	265.23	266.79	264.225	265.29	33892934.0
2018-10-26 16:00:00	SPY	ETF	265.27	270.0735	265.01	266.48	15584281.0
2018-10-26 16:30:00	SPY	ETF	266.5	266.6	265.7	265.7	562381.0
2018-10-26 17:00:00	SPY	ETF	265.89	265.95	265.33	265.89	774405.0
2018-10-26 17:30:00	SPY	ETF	265.88	266.43	265.33	266.43	109404.0
2018-10-26 18:00:00	SPY	ETF	266.43	266.51	266.32	266.43	74548.0
2018-10-26 18:30:00	SPY	ETF	266.42	266.45	266.35	266.37	24435.0
2018-10-26 19:00:00	SPY	ETF	266.37	266.37	266.23	266.3	14393.0
2018-10-26 19:30:00	SPY	ETF	266.34	266.5	266.21	266.37	21460.0
2018-10-26 04:00:00	QQQ	ETF	166.7	166.7	166.2	166.34	113263.0
2018-10-26 04:30:00	QQQ	ETF	166.46	166.56	165.77	166.01	58304.0
2018-10-26 05:00:00	QQQ	ETF	165.99	166.01	164.26	164.26	92850.0
2018-10-26 05:30:00	QQQ	ETF	164.39	164.4	163.86	164.22	163290.0
2018-10-26 06:00:00	QQQ	ETF	164.21	164.84	163.89	164.72	80588.0
2018-10-26 06:30:00	QQQ	ETF	164.82	165.1	164.26	164.5	106666.0
2018-10-26 07:00:00	QQQ	ETF	164.55	165.35	164.55	165.27	336642.0
2018-10-26 07:30:00	QQQ	ETF	165.29	165.41	164.76	165.0	402845.0
2018-10-26 08:00:00	QQQ	ETF	164.7201	166.7	164.46	164.77	565997.0
2018-10-26 08:30:00	QQQ	ETF	164.8	165.76	164.8	165.73	1148300.0
2018-10-26 09:00:00	QQQ	ETF	165.72	165.77	164.76	165.25	1806307.0
2018-10-26 09:30:00	QQQ	ETF	165.25	167.76	165.2	167.0	14382456.0
2018-10-26 10:00:00	QQQ	ETF	166.99	166.99	165.0	165.56	10925442.0
2018-10-26 10:30:00	QQQ	ETF	165.58	165.66	164.23	164.4	7957013.0
2018-10-26 11:00:00	QQQ	ETF	164.38	166.79	164.25	166.53	8286089.0
2018-10-26 11:30:00	QQQ	ETF	166.54	167.29	166.22	166.92	6829898.0
2018-10-26 12:00:00	QQQ	ETF	166.91	167.96	166.88	167.64	4961739.0
2018-10-26 12:30:00	QQQ	ETF	167.63	169.46	167.43	168.86	7377352.0

> showing 50 of 17,834 rows — these rows as CSV

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