PREVIEW / etf_30min / 2019-01-28

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-28.parquet
  size:    500 KB
  rows:    17,454

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-28 04:00:00	SPY	ETF	264.64	264.64	264.41	264.46	17408.0
2019-01-28 04:30:00	SPY	ETF	264.56	264.8	264.51	264.75	6157.0
2019-01-28 05:00:00	SPY	ETF	264.8	264.8	264.65	264.71	5838.0
2019-01-28 05:30:00	SPY	ETF	264.78	264.8	264.52	264.57	19124.0
2019-01-28 06:00:00	SPY	ETF	264.56	264.82	264.56	264.77	10700.0
2019-01-28 06:30:00	SPY	ETF	264.77	264.87	264.58	264.68	26725.0
2019-01-28 07:00:00	SPY	ETF	264.7	264.98	264.7	264.84	51366.0
2019-01-28 07:30:00	SPY	ETF	264.77	264.77	264.41	264.55	152727.0
2019-01-28 08:00:00	SPY	ETF	264.57	265.18	264.23	264.36	163711.0
2019-01-28 08:30:00	SPY	ETF	264.36	264.42	264.17	264.35	136891.0
2019-01-28 09:00:00	SPY	ETF	264.38	264.39	263.21	263.4	617718.0
2019-01-28 09:30:00	SPY	ETF	263.39	263.42	262.33	262.71	11050103.0
2019-01-28 10:00:00	SPY	ETF	262.71	263.32	262.21	263.25	7769800.0
2019-01-28 10:30:00	SPY	ETF	263.24	263.49	262.67	262.67	6599994.0
2019-01-28 11:00:00	SPY	ETF	262.68	263.2	262.35	263.0081	7242989.0
2019-01-28 11:30:00	SPY	ETF	263.01	263.2	261.98	262.0135	6080352.0
2019-01-28 12:00:00	SPY	ETF	262.02	262.74	261.79	262.66	4649790.0
2019-01-28 12:30:00	SPY	ETF	262.67	262.87	262.39	262.47	3469057.0
2019-01-28 13:00:00	SPY	ETF	262.44	263.19	262.31	262.8919	3608852.0
2019-01-28 13:30:00	SPY	ETF	262.9	263.5	262.895	263.26	3239106.0
2019-01-28 14:00:00	SPY	ETF	263.27	263.41	262.81	262.94	3403795.0
2019-01-28 14:30:00	SPY	ETF	262.95	263.75	262.95	263.53	4295614.0
2019-01-28 15:00:00	SPY	ETF	263.52	263.82	263.19	263.53	4470571.0
2019-01-28 15:30:00	SPY	ETF	263.53	263.83	263.11	263.79	10899534.0
2019-01-28 16:00:00	SPY	ETF	263.78	263.85	263.58	263.76	5545520.0
2019-01-28 16:30:00	SPY	ETF	263.75	263.75	263.56	263.65	224934.0
2019-01-28 17:00:00	SPY	ETF	263.64	263.64	263.53	263.62	22149.0
2019-01-28 17:30:00	SPY	ETF	263.62	263.69	263.56	263.6	56301.0
2019-01-28 18:00:00	SPY	ETF	263.6	263.6	263.2	263.25	107686.0
2019-01-28 18:30:00	SPY	ETF	263.25	263.28	263.12	263.16	23191.0
2019-01-28 19:00:00	SPY	ETF	263.12	263.74	262.82	262.91	377051.0
2019-01-28 19:30:00	SPY	ETF	262.81	262.85	262.54	262.56	57099.0
2019-01-28 04:00:00	QQQ	ETF	164.41	164.48	164.18	164.19	7928.0
2019-01-28 04:30:00	QQQ	ETF	164.22	164.33	164.22	164.33	1050.0
2019-01-28 05:00:00	QQQ	ETF	164.39	164.41	164.36	164.41	5800.0
2019-01-28 05:30:00	QQQ	ETF	164.4	164.44	164.27	164.27	17888.0
2019-01-28 06:00:00	QQQ	ETF	164.29	164.44	164.29	164.38	7164.0
2019-01-28 06:30:00	QQQ	ETF	164.4	164.43	164.26	164.26	5810.0
2019-01-28 07:00:00	QQQ	ETF	164.28	164.56	164.25	164.45	53908.0
2019-01-28 07:30:00	QQQ	ETF	164.47	164.47	164.24	164.27	99658.0
2019-01-28 08:00:00	QQQ	ETF	164.26	164.82	164.1	164.19	139371.0
2019-01-28 08:30:00	QQQ	ETF	164.2	164.32	164.05	164.29	41291.0
2019-01-28 09:00:00	QQQ	ETF	164.31	164.32	162.78	163.03	829887.0
2019-01-28 09:30:00	QQQ	ETF	163.03	163.11	161.86	162.35	5360585.0
2019-01-28 10:00:00	QQQ	ETF	162.34	162.86	161.99	162.81	2736579.0
2019-01-28 10:30:00	QQQ	ETF	162.78	162.91	162.34	162.38	1656142.0
2019-01-28 11:00:00	QQQ	ETF	162.35	162.79	162.1519	162.59	1472048.0
2019-01-28 11:30:00	QQQ	ETF	162.61	162.77	161.88	161.93	1912315.0
2019-01-28 12:00:00	QQQ	ETF	161.92	162.44	161.75	162.38	1340827.0
2019-01-28 12:30:00	QQQ	ETF	162.39	162.51	162.13	162.18	854364.0

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

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