PREVIEW / etf_30min / 2019-03-22

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-03-22.parquet
  size:    510 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
2019-03-22 04:00:00	SPY	ETF	284.73	284.86	284.68	284.81	4701.0
2019-03-22 04:30:00	SPY	ETF	284.67	284.67	283.42	283.46	27401.0
2019-03-22 05:00:00	SPY	ETF	283.6	283.92	283.38	283.44	6309.0
2019-03-22 05:30:00	SPY	ETF	283.35	283.7	283.35	283.64	23026.0
2019-03-22 06:00:00	SPY	ETF	283.58	283.69	283.34	283.44	51759.0
2019-03-22 06:30:00	SPY	ETF	283.58	283.78	283.52	283.7	65611.0
2019-03-22 07:00:00	SPY	ETF	283.71	283.86	283.55	283.82	163731.0
2019-03-22 07:30:00	SPY	ETF	283.79	283.85	283.49	283.69	212081.0
2019-03-22 08:00:00	SPY	ETF	283.63	284.92	282.91	283.26	693658.0
2019-03-22 08:30:00	SPY	ETF	283.21	283.61	283.08	283.49	509754.0
2019-03-22 09:00:00	SPY	ETF	283.41	283.43	283.07	283.21	394547.0
2019-03-22 09:30:00	SPY	ETF	283.22	283.8034	281.73	281.93	10637822.0
2019-03-22 10:00:00	SPY	ETF	281.94	283.01	281.8	282.12	8123846.0
2019-03-22 10:30:00	SPY	ETF	282.13	282.62	281.41	281.4599	6949627.0
2019-03-22 11:00:00	SPY	ETF	281.45	281.87	281.07	281.18	8305110.0
2019-03-22 11:30:00	SPY	ETF	281.17	281.4297	279.62	279.64	10664516.0
2019-03-22 12:00:00	SPY	ETF	279.65	280.42	279.6	279.95	7783902.0
2019-03-22 12:30:00	SPY	ETF	279.94	280.3578	279.33	280.25	7767004.0
2019-03-22 13:00:00	SPY	ETF	280.25	280.63	279.94	280.1	6862813.0
2019-03-22 13:30:00	SPY	ETF	280.1	280.52	279.65	279.81	3680871.0
2019-03-22 14:00:00	SPY	ETF	279.8	281.1	279.74	280.85	5733594.0
2019-03-22 14:30:00	SPY	ETF	280.85	281.44	280.38	281.185	6514222.0
2019-03-22 15:00:00	SPY	ETF	281.19	281.51	280.28	280.32	6569810.0
2019-03-22 15:30:00	SPY	ETF	280.31	280.35	279.18	279.25	18390113.0
2019-03-22 16:00:00	SPY	ETF	279.26	280.03	279.2317	279.65	8270733.0
2019-03-22 16:30:00	SPY	ETF	279.66	279.68	279.25	279.35	431378.0
2019-03-22 17:00:00	SPY	ETF	279.46	279.7014	279.1	279.13	234981.0
2019-03-22 17:30:00	SPY	ETF	279.11	279.74	279.06	279.27	478325.0
2019-03-22 18:00:00	SPY	ETF	279.21	279.74	279.21	279.5	432570.0
2019-03-22 18:30:00	SPY	ETF	279.46	279.5	279.4	279.42	10664.0
2019-03-22 19:00:00	SPY	ETF	279.47	279.58	279.4	279.5	32851.0
2019-03-22 19:30:00	SPY	ETF	279.5	279.58	279.2	279.25	38913.0
2019-03-22 04:00:00	QQQ	ETF	182.78	182.85	182.73	182.82	4545.0
2019-03-22 04:30:00	QQQ	ETF	182.55	182.55	181.93	181.99	20257.0
2019-03-22 05:00:00	QQQ	ETF	182.01	182.3	181.91	181.98	19105.0
2019-03-22 05:30:00	QQQ	ETF	181.94	182.2	181.94	182.14	5820.0
2019-03-22 06:00:00	QQQ	ETF	182.17	182.17	181.88	182.0	16225.0
2019-03-22 06:30:00	QQQ	ETF	182.02	182.11	181.99	181.99	85731.0
2019-03-22 07:00:00	QQQ	ETF	182.03	182.19	181.99	182.17	32011.0
2019-03-22 07:30:00	QQQ	ETF	182.13	182.23	182.0	182.11	48748.0
2019-03-22 08:00:00	QQQ	ETF	182.03	182.67	181.62	181.85	186688.0
2019-03-22 08:30:00	QQQ	ETF	181.82	182.09	181.67	181.97	206995.0
2019-03-22 09:00:00	QQQ	ETF	181.93	181.95	181.67	181.76	227310.0
2019-03-22 09:30:00	QQQ	ETF	181.76	182.27	180.53	180.725	6592346.0
2019-03-22 10:00:00	QQQ	ETF	180.73	181.6985	180.67	181.19	5118605.0
2019-03-22 10:30:00	QQQ	ETF	181.2	181.42	180.421	180.55	3235246.0
2019-03-22 11:00:00	QQQ	ETF	180.541	180.72	180.17	180.21	3807790.0
2019-03-22 11:30:00	QQQ	ETF	180.2	180.38	179.1	179.11	5663269.0
2019-03-22 12:00:00	QQQ	ETF	179.12	179.73	179.0899	179.38	3726862.0
2019-03-22 12:30:00	QQQ	ETF	179.37	179.725	178.93	179.58	4152875.0

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

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