PREVIEW / etf_30min / 2018-10-29

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-29.parquet
  size:    503 KB
  rows:    17,519

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-29 04:00:00	SPY	ETF	266.32	266.57	265.89	265.94	46303.0
2018-10-29 04:30:00	SPY	ETF	265.85	266.29	265.83	266.11	50973.0
2018-10-29 05:00:00	SPY	ETF	266.06	266.68	265.86	266.63	26846.0
2018-10-29 05:30:00	SPY	ETF	266.65	267.74	266.65	267.66	54534.0
2018-10-29 06:00:00	SPY	ETF	267.62	267.96	267.5	267.89	76402.0
2018-10-29 06:30:00	SPY	ETF	267.81	268.84	267.76	268.63	200148.0
2018-10-29 07:00:00	SPY	ETF	268.63	269.66	268.54	269.55	259052.0
2018-10-29 07:30:00	SPY	ETF	269.55	269.56	268.66	268.75	263104.0
2018-10-29 08:00:00	SPY	ETF	268.75	269.61	268.59	269.19	361220.0
2018-10-29 08:30:00	SPY	ETF	269.16	269.37	265.8	269.33	263384.0
2018-10-29 09:00:00	SPY	ETF	269.3	269.32	268.8	268.8	359465.0
2018-10-29 09:30:00	SPY	ETF	268.8	269.25	268.26	269.02	12690636.0
2018-10-29 10:00:00	SPY	ETF	269.03	270.25	269.03	269.75	9655547.0
2018-10-29 10:30:00	SPY	ETF	269.76	269.95	268.52	269.13	6668806.0
2018-10-29 11:00:00	SPY	ETF	269.15	269.42	267.81	268.41	8146138.0
2018-10-29 11:30:00	SPY	ETF	268.42	268.95	267.41	267.42	5225999.0
2018-10-29 12:00:00	SPY	ETF	267.42	267.58	266.17	266.68	11963698.0
2018-10-29 12:30:00	SPY	ETF	266.67	267.59	266.2	266.63	7703504.0
2018-10-29 13:00:00	SPY	ETF	266.64	267.89	266.6	266.84	5462111.0
2018-10-29 13:30:00	SPY	ETF	266.84	267.87	266.76	266.99	4624905.0
2018-10-29 14:00:00	SPY	ETF	266.99	267.0	265.2	265.24	11161042.0
2018-10-29 14:30:00	SPY	ETF	265.26	265.83	264.25	264.54	8817116.0
2018-10-29 15:00:00	SPY	ETF	264.55	264.6199	262.02	262.49	15266124.0
2018-10-29 15:30:00	SPY	ETF	262.49	263.84	259.85	263.8	35869226.0
2018-10-29 16:00:00	SPY	ETF	263.79	264.1	263.26	263.6644	9600198.0
2018-10-29 16:30:00	SPY	ETF	263.71	263.83	263.37	263.52	752497.0
2018-10-29 17:00:00	SPY	ETF	265.4031	265.4031	263.46	263.47	1492890.0
2018-10-29 17:30:00	SPY	ETF	263.48	263.86	263.36	263.44	92819.0
2018-10-29 18:00:00	SPY	ETF	263.46	263.9	263.2	263.4	1419773.0
2018-10-29 18:30:00	SPY	ETF	263.35	263.6	263.18	263.47	43212.0
2018-10-29 19:00:00	SPY	ETF	263.4	263.85	263.4	263.73	60275.0
2018-10-29 19:30:00	SPY	ETF	263.77	263.95	263.52	263.75	151638.0
2018-10-29 04:00:00	QQQ	ETF	168.0	168.29	167.75	167.75	45057.0
2018-10-29 04:30:00	QQQ	ETF	167.69	167.95	167.69	167.82	8520.0
2018-10-29 05:00:00	QQQ	ETF	167.71	168.57	167.68	168.55	61524.0
2018-10-29 05:30:00	QQQ	ETF	168.54	169.27	168.53	169.21	125983.0
2018-10-29 06:00:00	QQQ	ETF	169.14	169.27	168.97	169.12	30942.0
2018-10-29 06:30:00	QQQ	ETF	169.17	169.5	169.09	169.39	63230.0
2018-10-29 07:00:00	QQQ	ETF	169.34	170.04	169.25	170.04	144970.0
2018-10-29 07:30:00	QQQ	ETF	170.03	170.03	169.32	169.38	152219.0
2018-10-29 08:00:00	QQQ	ETF	169.27	169.98	167.75	169.71	709524.0
2018-10-29 08:30:00	QQQ	ETF	169.63	169.76	169.47	169.66	591625.0
2018-10-29 09:00:00	QQQ	ETF	169.72	169.72	169.12	169.15	334856.0
2018-10-29 09:30:00	QQQ	ETF	169.16	169.54	168.36	168.93	7372937.0
2018-10-29 10:00:00	QQQ	ETF	168.92	169.86	168.92	169.11	5617954.0
2018-10-29 10:30:00	QQQ	ETF	169.1297	169.3	168.13	168.28	4123924.0
2018-10-29 11:00:00	QQQ	ETF	168.29	168.59	167.09	167.615	5001703.0
2018-10-29 11:30:00	QQQ	ETF	167.62	168.01	166.69	166.71	4497693.0
2018-10-29 12:00:00	QQQ	ETF	166.71	166.83	165.08	165.44	7108825.0
2018-10-29 12:30:00	QQQ	ETF	165.44	166.48	165.09	165.77	5816357.0

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

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