PREVIEW / etf_30min / 2019-01-18

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-18.parquet
  size:    514 KB
  rows:    17,883

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
2019-01-18 04:00:00	SPY	ETF	263.56	263.8	263.5	263.75	89424.0
2019-01-18 04:30:00	SPY	ETF	263.77	263.81	263.63	263.73	18425.0
2019-01-18 05:00:00	SPY	ETF	263.74	263.82	263.41	263.5	17679.0
2019-01-18 05:30:00	SPY	ETF	263.47	263.64	263.34	263.57	14355.0
2019-01-18 06:00:00	SPY	ETF	263.59	263.79	263.55	263.79	49814.0
2019-01-18 06:30:00	SPY	ETF	263.8	264.23	263.79	264.14	62150.0
2019-01-18 07:00:00	SPY	ETF	264.16	264.32	263.99	264.07	96368.0
2019-01-18 07:30:00	SPY	ETF	264.1	264.19	263.98	264.08	115902.0
2019-01-18 08:00:00	SPY	ETF	264.12	266.55	263.5	264.0	290111.0
2019-01-18 08:30:00	SPY	ETF	264.04	264.31	263.88	264.25	412624.0
2019-01-18 09:00:00	SPY	ETF	264.25	265.14	264.14	264.94	1185868.0
2019-01-18 09:30:00	SPY	ETF	264.98	265.15	264.2	264.5174	12048389.0
2019-01-18 10:00:00	SPY	ETF	264.51	265.46	264.1	264.76	22898394.0
2019-01-18 10:30:00	SPY	ETF	264.77	265.76	264.715	265.64	8768540.0
2019-01-18 11:00:00	SPY	ETF	265.63	266.31	265.55	266.21	5592029.0
2019-01-18 11:30:00	SPY	ETF	266.22	266.48	265.985	266.48	5349276.0
2019-01-18 12:00:00	SPY	ETF	266.49	266.95	266.16	266.8	6343111.0
2019-01-18 12:30:00	SPY	ETF	266.8	266.98	266.4	266.7246	3998804.0
2019-01-18 13:00:00	SPY	ETF	266.73	266.89	266.11	266.25	4094353.0
2019-01-18 13:30:00	SPY	ETF	266.24	266.49	265.96	266.47	5640852.0
2019-01-18 14:00:00	SPY	ETF	266.46	266.5	265.86	265.97	3538278.0
2019-01-18 14:30:00	SPY	ETF	265.96	266.18	265.57	266.04	4311334.0
2019-01-18 15:00:00	SPY	ETF	266.05	266.21	265.7501	266.0	5932427.0
2019-01-18 15:30:00	SPY	ETF	266.01	266.57	265.73	266.42	15025735.0
2019-01-18 16:00:00	SPY	ETF	266.44	266.6	266.28	266.51	9136875.0
2019-01-18 16:30:00	SPY	ETF	266.51	267.05	266.48	267.04	4239258.0
2019-01-18 17:00:00	SPY	ETF	266.98	267.0	266.46	266.69	1258861.0
2019-01-18 17:30:00	SPY	ETF	266.68	266.87	266.46	266.87	3166988.0
2019-01-18 18:00:00	SPY	ETF	266.89	266.95	266.65	266.65	93600.0
2019-01-18 18:30:00	SPY	ETF	266.65	266.66	266.4	266.46	361381.0
2019-01-18 19:00:00	SPY	ETF	266.45	266.53	266.37	266.53	100080.0
2019-01-18 19:30:00	SPY	ETF	266.47	266.6	266.46	266.58	24096.0
2019-01-18 04:00:00	QQQ	ETF	163.72	164.05	163.72	163.99	7691.0
2019-01-18 04:30:00	QQQ	ETF	164.04	164.17	163.99	164.07	8010.0
2019-01-18 05:00:00	QQQ	ETF	164.12	164.12	163.78	163.8	6090.0
2019-01-18 05:30:00	QQQ	ETF	163.75	163.87	163.71	163.82	9450.0
2019-01-18 06:00:00	QQQ	ETF	163.88	163.93	163.81	163.87	23720.0
2019-01-18 06:30:00	QQQ	ETF	163.93	164.2	163.9	164.16	17015.0
2019-01-18 07:00:00	QQQ	ETF	164.15	164.26	164.03	164.1	44392.0
2019-01-18 07:30:00	QQQ	ETF	164.14	164.23	164.09	164.16	63295.0
2019-01-18 08:00:00	QQQ	ETF	164.18	164.27	163.63	164.21	106383.0
2019-01-18 08:30:00	QQQ	ETF	164.21	164.4	164.14	164.34	139378.0
2019-01-18 09:00:00	QQQ	ETF	164.34	165.03	164.24	164.85	707105.0
2019-01-18 09:30:00	QQQ	ETF	164.84	164.99	163.91	164.1585	5204720.0
2019-01-18 10:00:00	QQQ	ETF	164.15	164.87	163.82	164.47	4437953.0
2019-01-18 10:30:00	QQQ	ETF	164.48	165.27	164.44	165.25	3356098.0
2019-01-18 11:00:00	QQQ	ETF	165.25	165.7573	165.19	165.69	3282095.0
2019-01-18 11:30:00	QQQ	ETF	165.69	165.74	165.38	165.67	1546414.0
2019-01-18 12:00:00	QQQ	ETF	165.68	165.96	165.5514	165.89	2656289.0
2019-01-18 12:30:00	QQQ	ETF	165.895	166.02	165.69	165.86	1469333.0

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

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