PREVIEW / etf_30min / 2019-03-21

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-03-21.parquet
  size:    499 KB
  rows:    17,211

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-21 04:00:00	SPY	ETF	280.84	280.97	280.75	280.93	2379.0
2019-03-21 04:30:00	SPY	ETF	281.04	281.13	280.84	280.84	1316.0
2019-03-21 05:00:00	SPY	ETF	280.91	281.32	280.91	281.09	24210.0
2019-03-21 05:30:00	SPY	ETF	281.0	281.26	281.0	281.11	32020.0
2019-03-21 06:00:00	SPY	ETF	281.04	281.2	281.0	281.2	5160.0
2019-03-21 06:30:00	SPY	ETF	281.17	281.28	281.14	281.23	59220.0
2019-03-21 07:00:00	SPY	ETF	281.21	281.25	280.18	280.24	379587.0
2019-03-21 07:30:00	SPY	ETF	280.2	280.45	280.02	280.2	321068.0
2019-03-21 08:00:00	SPY	ETF	280.3001	281.5	280.07	280.19	478106.0
2019-03-21 08:30:00	SPY	ETF	280.17	280.49	280.01	280.45	388091.0
2019-03-21 09:00:00	SPY	ETF	280.43	280.73	280.43	280.61	293688.0
2019-03-21 09:30:00	SPY	ETF	280.64	282.42	280.59	282.125	7354030.0
2019-03-21 10:00:00	SPY	ETF	282.13	282.72	282.1	282.61	4106713.0
2019-03-21 10:30:00	SPY	ETF	282.62	283.13	282.48	283.12	3433287.0
2019-03-21 11:00:00	SPY	ETF	283.115	283.61	283.11	283.305	5196912.0
2019-03-21 11:30:00	SPY	ETF	283.305	284.25	283.18	284.2	4609692.0
2019-03-21 12:00:00	SPY	ETF	284.19	284.2369	283.4	283.46	4409481.0
2019-03-21 12:30:00	SPY	ETF	283.46	283.6	283.26	283.54	2238509.0
2019-03-21 13:00:00	SPY	ETF	283.55	284.0925	283.54	284.09	3885381.0
2019-03-21 13:30:00	SPY	ETF	284.09	284.27	283.77	284.07	3734232.0
2019-03-21 14:00:00	SPY	ETF	284.0701	284.8	284.0701	284.775	6170907.0
2019-03-21 14:30:00	SPY	ETF	284.78	285.0	284.7	284.73	4945177.0
2019-03-21 15:00:00	SPY	ETF	284.74	285.18	284.43	284.67	6440654.0
2019-03-21 15:30:00	SPY	ETF	284.67	285.12	284.47	284.67	13662049.0
2019-03-21 16:00:00	SPY	ETF	284.67	284.9	284.46	284.85	5452357.0
2019-03-21 16:30:00	SPY	ETF	284.85	284.88	284.58	284.6	151226.0
2019-03-21 17:00:00	SPY	ETF	284.6	284.62	284.44	284.51	83158.0
2019-03-21 17:30:00	SPY	ETF	284.53	284.55	284.48	284.52	41259.0
2019-03-21 18:00:00	SPY	ETF	284.5	284.79	284.49	284.78	96212.0
2019-03-21 18:30:00	SPY	ETF	284.78	284.78	284.57	284.67	13616.0
2019-03-21 19:00:00	SPY	ETF	284.61	284.64	284.55	284.62	14411.0
2019-03-21 19:30:00	SPY	ETF	284.63	284.8	284.63	284.79	22778.0
2019-03-21 04:00:00	QQQ	ETF	179.56	179.65	179.5	179.64	5760.0
2019-03-21 04:30:00	QQQ	ETF	179.8	179.84	179.76	179.81	6417.0
2019-03-21 05:00:00	QQQ	ETF	179.71	179.93	179.71	179.79	8809.0
2019-03-21 05:30:00	QQQ	ETF	179.79	179.94	179.77	179.84	18784.0
2019-03-21 06:00:00	QQQ	ETF	179.83	179.95	179.78	179.93	22464.0
2019-03-21 06:30:00	QQQ	ETF	179.91	180.01	179.88	179.97	12725.0
2019-03-21 07:00:00	QQQ	ETF	179.97	179.97	178.95	178.99	285689.0
2019-03-21 07:30:00	QQQ	ETF	178.98	179.17	178.85	179.01	125405.0
2019-03-21 08:00:00	QQQ	ETF	179.75	179.94	178.81	178.85	203979.0
2019-03-21 08:30:00	QQQ	ETF	178.85	179.11	178.78	179.09	108485.0
2019-03-21 09:00:00	QQQ	ETF	179.09	179.25	179.08	179.15	137356.0
2019-03-21 09:30:00	QQQ	ETF	179.2	180.68	179.2	180.38	4469866.0
2019-03-21 10:00:00	QQQ	ETF	180.38	180.9	180.34	180.81	2498246.0
2019-03-21 10:30:00	QQQ	ETF	180.82	181.19	180.74	181.1784	2721089.0
2019-03-21 11:00:00	QQQ	ETF	181.18	181.59	181.12	181.19	2870126.0
2019-03-21 11:30:00	QQQ	ETF	181.19	181.67	181.07	181.65	2503077.0
2019-03-21 12:00:00	QQQ	ETF	181.64	181.69	181.24	181.27	2118559.0
2019-03-21 12:30:00	QQQ	ETF	181.28	181.46	181.12	181.37	1474042.0

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

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