PREVIEW / etf_30min / 2018-12-12

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-12-12.parquet
  size:    502 KB
  rows:    17,384

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-12-12 04:00:00	SPY	ETF	265.5	266.53	265.5	266.43	58555.0
2018-12-12 04:30:00	SPY	ETF	266.43	266.95	266.43	266.82	16003.0
2018-12-12 05:00:00	SPY	ETF	266.72	266.8	266.45	266.48	22163.0
2018-12-12 05:30:00	SPY	ETF	266.44	266.81	266.44	266.61	15145.0
2018-12-12 06:00:00	SPY	ETF	266.6	266.6	266.09	266.52	43903.0
2018-12-12 06:30:00	SPY	ETF	266.52	266.57	266.09	266.44	86745.0
2018-12-12 07:00:00	SPY	ETF	266.36	266.66	266.06	266.66	84104.0
2018-12-12 07:30:00	SPY	ETF	266.65	267.15	266.62	266.72	190151.0
2018-12-12 08:00:00	SPY	ETF	266.32	267.1199	264.96	266.72	165872.0
2018-12-12 08:30:00	SPY	ETF	266.71	267.99	266.57	267.68	985023.0
2018-12-12 09:00:00	SPY	ETF	267.68	267.7	267.37	267.51	573631.0
2018-12-12 09:30:00	SPY	ETF	267.47	267.69	266.47	267.0697	9868783.0
2018-12-12 10:00:00	SPY	ETF	267.075	268.05	266.705	267.5	7777271.0
2018-12-12 10:30:00	SPY	ETF	267.49	268.24	266.79	268.11	6526901.0
2018-12-12 11:00:00	SPY	ETF	268.11	268.46	267.74	267.95	4600533.0
2018-12-12 11:30:00	SPY	ETF	267.96	268.48	267.5	268.36	3892682.0
2018-12-12 12:00:00	SPY	ETF	268.37	268.64	267.87	268.4	3853801.0
2018-12-12 12:30:00	SPY	ETF	268.41	268.77	267.87	268.66	4329313.0
2018-12-12 13:00:00	SPY	ETF	268.66	268.9485	268.53	268.791	2412463.0
2018-12-12 13:30:00	SPY	ETF	268.8	268.84	267.92	268.22	3203360.0
2018-12-12 14:00:00	SPY	ETF	268.2	268.26	266.46	266.73	7037543.0
2018-12-12 14:30:00	SPY	ETF	266.72	267.02	265.93	266.81	8355539.0
2018-12-12 15:00:00	SPY	ETF	266.815	269.0	266.33	266.42	7412273.0
2018-12-12 15:30:00	SPY	ETF	266.42	267.29	265.37	265.51	15132470.0
2018-12-12 16:00:00	SPY	ETF	265.51	265.9374	265.08	265.46	9012745.0
2018-12-12 16:30:00	SPY	ETF	265.46	265.46	265.03	265.42	494563.0
2018-12-12 17:00:00	SPY	ETF	265.42	265.46	265.25	265.39	45926.0
2018-12-12 17:30:00	SPY	ETF	265.4	265.65	265.31	265.61	122088.0
2018-12-12 18:00:00	SPY	ETF	265.63	265.98	265.53	265.79	87888.0
2018-12-12 18:30:00	SPY	ETF	265.79	266.18	265.79	266.14	46187.0
2018-12-12 19:00:00	SPY	ETF	266.16	266.18	265.88	266.15	20641.0
2018-12-12 19:30:00	SPY	ETF	266.18	266.18	265.86	265.86	69059.0
2018-12-12 04:00:00	QQQ	ETF	164.7	165.52	164.7	165.45	15864.0
2018-12-12 04:30:00	QQQ	ETF	165.48	165.9	165.48	165.74	70375.0
2018-12-12 05:00:00	QQQ	ETF	165.77	165.77	165.5	165.53	12066.0
2018-12-12 05:30:00	QQQ	ETF	165.55	165.83	165.5	165.6	22770.0
2018-12-12 06:00:00	QQQ	ETF	165.49	165.5	165.29	165.5	7047.0
2018-12-12 06:30:00	QQQ	ETF	165.5	165.5	165.2	165.27	9098.0
2018-12-12 07:00:00	QQQ	ETF	165.35	165.57	165.15	165.57	51600.0
2018-12-12 07:30:00	QQQ	ETF	165.5	165.9	165.5	165.57	70114.0
2018-12-12 08:00:00	QQQ	ETF	165.35	165.8999	163.61	165.53	905302.0
2018-12-12 08:30:00	QQQ	ETF	165.51	166.41	165.38	166.27	332627.0
2018-12-12 09:00:00	QQQ	ETF	166.27	166.32	165.99	166.06	221755.0
2018-12-12 09:30:00	QQQ	ETF	166.06	166.14	165.34	166.11	5485312.0
2018-12-12 10:00:00	QQQ	ETF	166.11	166.75	165.89	166.32	4499556.0
2018-12-12 10:30:00	QQQ	ETF	166.32	166.97	166.08	166.8799	3100150.0
2018-12-12 11:00:00	QQQ	ETF	166.88	167.43	166.68	167.11	2722159.0
2018-12-12 11:30:00	QQQ	ETF	167.11	167.47	166.85	167.32	2247597.0
2018-12-12 12:00:00	QQQ	ETF	167.33	167.5	166.86	167.22	2378527.0
2018-12-12 12:30:00	QQQ	ETF	167.23	167.51	166.97	167.43	1762460.0

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

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