PREVIEW / etf_30min / 2019-05-13

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-05-13.parquet
  size:    526 KB
  rows:    18,472

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-05-13 04:00:00	SPY	ETF	284.34	284.73	284.11	284.7	36365.0
2019-05-13 04:30:00	SPY	ETF	284.71	284.96	284.58	284.66	42860.0
2019-05-13 05:00:00	SPY	ETF	284.71	285.03	284.71	284.76	14496.0
2019-05-13 05:30:00	SPY	ETF	284.85	285.1	284.84	285.1	39373.0
2019-05-13 06:00:00	SPY	ETF	285.11	285.11	284.72	284.81	69596.0
2019-05-13 06:30:00	SPY	ETF	284.83	285.02	284.57	284.89	161308.0
2019-05-13 07:00:00	SPY	ETF	284.91	284.95	284.43	284.55	324196.0
2019-05-13 07:30:00	SPY	ETF	284.55	284.75	284.06	284.11	373580.0
2019-05-13 08:00:00	SPY	ETF	284.14	285.53	282.54	283.04	2150874.0
2019-05-13 08:30:00	SPY	ETF	283.02	283.13	282.59	282.72	1477863.0
2019-05-13 09:00:00	SPY	ETF	282.71	282.98	282.35	282.42	1438091.0
2019-05-13 09:30:00	SPY	ETF	282.42	283.49	281.85	282.16	13703106.0
2019-05-13 10:00:00	SPY	ETF	282.16	282.16	281.07	281.72	11022544.0
2019-05-13 10:30:00	SPY	ETF	281.71	282.54	281.32	281.86	6596361.0
2019-05-13 11:00:00	SPY	ETF	281.85	282.1	280.96	281.23	5615272.0
2019-05-13 11:30:00	SPY	ETF	281.2287	281.56	280.67	281.5	5924949.0
2019-05-13 12:00:00	SPY	ETF	281.49	281.51	280.48	280.72	4190548.0
2019-05-13 12:30:00	SPY	ETF	280.71	281.16	280.3	280.32	4100655.0
2019-05-13 13:00:00	SPY	ETF	280.31	280.49	279.93	280.025	6681347.0
2019-05-13 13:30:00	SPY	ETF	280.02	281.19	279.98	281.12	7003257.0
2019-05-13 14:00:00	SPY	ETF	281.12	281.97	280.54	281.55	9324788.0
2019-05-13 14:30:00	SPY	ETF	281.56	282.21	280.88	281.79	5897212.0
2019-05-13 15:00:00	SPY	ETF	281.78	282.24	280.7	280.82	7154937.0
2019-05-13 15:30:00	SPY	ETF	280.81	281.28	280.2	280.96	19062800.0
2019-05-13 16:00:00	SPY	ETF	281.0	281.09	280.34	280.39	10597757.0
2019-05-13 16:30:00	SPY	ETF	280.43	287.9383	280.19	280.54	739457.0
2019-05-13 17:00:00	SPY	ETF	280.51	287.9383	280.39	280.49	249435.0
2019-05-13 17:30:00	SPY	ETF	280.45	280.86	280.36	280.86	87451.0
2019-05-13 18:00:00	SPY	ETF	280.4	280.55	279.74	280.05	106022.0
2019-05-13 18:30:00	SPY	ETF	280.05	280.56	280.05	280.44	25681.0
2019-05-13 19:00:00	SPY	ETF	280.43	280.5	280.37	280.45	11224.0
2019-05-13 19:30:00	SPY	ETF	280.45	280.45	280.07	280.11	44460.0
2019-05-13 04:00:00	QQQ	ETF	182.07	182.27	181.9	182.24	61804.0
2019-05-13 04:30:00	QQQ	ETF	182.28	182.4	182.11	182.11	12866.0
2019-05-13 05:00:00	QQQ	ETF	182.24	182.4	182.2	182.29	19174.0
2019-05-13 05:30:00	QQQ	ETF	182.29	182.45	182.25	182.37	32922.0
2019-05-13 06:00:00	QQQ	ETF	182.43	182.43	182.08	182.13	7210.0
2019-05-13 06:30:00	QQQ	ETF	182.22	182.35	181.97	182.23	70456.0
2019-05-13 07:00:00	QQQ	ETF	182.32	182.32	181.9	182.01	74880.0
2019-05-13 07:30:00	QQQ	ETF	182.05	182.19	181.5	181.59	178286.0
2019-05-13 08:00:00	QQQ	ETF	182.15	183.64	180.24	180.58	1222493.0
2019-05-13 08:30:00	QQQ	ETF	180.58	180.72	180.34	180.49	436100.0
2019-05-13 09:00:00	QQQ	ETF	180.49	180.6	180.24	180.3	433458.0
2019-05-13 09:30:00	QQQ	ETF	180.3	181.26	179.57	179.9699	8096529.0
2019-05-13 10:00:00	QQQ	ETF	179.93	179.95	179.01	179.38	5327494.0
2019-05-13 10:30:00	QQQ	ETF	179.37	180.11	179.06	179.625	3073156.0
2019-05-13 11:00:00	QQQ	ETF	179.63	179.86	178.78	179.03	3029622.0
2019-05-13 11:30:00	QQQ	ETF	179.03	179.299	178.55	179.189	3079582.0
2019-05-13 12:00:00	QQQ	ETF	179.1799	179.19	178.59	178.8	1831180.0
2019-05-13 12:30:00	QQQ	ETF	178.81	179.21	178.61	178.62	1947993.0

> showing 50 of 18,472 rows — these rows as CSV

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