PREVIEW / etf_30min / 2020-04-20

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-20.parquet
  size:    583 KB
  rows:    21,433

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
2020-04-20 04:00:00	SPY	ETF	285.84	285.84	284.67	284.67	75192.0
2020-04-20 04:30:00	SPY	ETF	284.62	285.15	284.57	285.15	28943.0
2020-04-20 05:00:00	SPY	ETF	285.3	285.39	284.99	285.05	49751.0
2020-04-20 05:30:00	SPY	ETF	285.07	285.11	283.83	283.83	129158.0
2020-04-20 06:00:00	SPY	ETF	284.03	284.05	282.44	282.75	174650.0
2020-04-20 06:30:00	SPY	ETF	282.73	283.23	282.64	282.85	306516.0
2020-04-20 07:00:00	SPY	ETF	282.85	283.34	281.84	282.0	847089.0
2020-04-20 07:30:00	SPY	ETF	282.0	282.53	281.25	281.53	749536.0
2020-04-20 08:00:00	SPY	ETF	281.4	287.61	281.28	282.0	851387.0
2020-04-20 08:30:00	SPY	ETF	282.0	282.39	281.6796	282.0	480539.0
2020-04-20 09:00:00	SPY	ETF	281.95	282.69	281.61	282.63	640065.0
2020-04-20 09:30:00	SPY	ETF	282.61	283.99	282.23	283.35	9776559.0
2020-04-20 10:00:00	SPY	ETF	283.35	284.09	282.85	283.69	6022920.0
2020-04-20 10:30:00	SPY	ETF	283.69	285.595	283.54	285.15	8884860.0
2020-04-20 11:00:00	SPY	ETF	285.14	286.7912	284.71	285.35	8258409.0
2020-04-20 11:30:00	SPY	ETF	285.35	286.29	285.0	285.934	4962202.0
2020-04-20 12:00:00	SPY	ETF	285.93	286.01	285.136	285.31	3768057.0
2020-04-20 12:30:00	SPY	ETF	285.29	285.99	285.28	285.4	3513082.0
2020-04-20 13:00:00	SPY	ETF	285.42	285.45	284.0965	284.57	4403273.0
2020-04-20 13:30:00	SPY	ETF	284.565	285.03	284.11	284.8445	3518657.0
2020-04-20 14:00:00	SPY	ETF	284.82	285.13	282.55	282.634	6778203.0
2020-04-20 14:30:00	SPY	ETF	282.63	283.62	281.656	281.72	7918762.0
2020-04-20 15:00:00	SPY	ETF	281.71	282.61	281.35	282.44	8112662.0
2020-04-20 15:30:00	SPY	ETF	282.45	283.04	281.49	281.61	12724644.0
2020-04-20 16:00:00	SPY	ETF	281.61	281.95	280.5	281.0	3446117.0
2020-04-20 16:30:00	SPY	ETF	281.0	284.3811	280.9	281.33	578072.0
2020-04-20 17:00:00	SPY	ETF	281.31	281.6	281.31	281.46	497906.0
2020-04-20 17:30:00	SPY	ETF	281.4	281.63	281.27	281.35	103091.0
2020-04-20 18:00:00	SPY	ETF	281.35	281.92	281.05	281.5	180398.0
2020-04-20 18:30:00	SPY	ETF	281.55	282.86	281.49	282.57	209010.0
2020-04-20 19:00:00	SPY	ETF	282.63	282.98	282.14	282.16	219969.0
2020-04-20 19:30:00	SPY	ETF	282.16	282.52	281.51	282.03	173101.0
2020-04-20 04:00:00	QQQ	ETF	214.23	214.33	213.5	213.5	51949.0
2020-04-20 04:30:00	QQQ	ETF	213.52	213.94	213.52	213.94	33020.0
2020-04-20 05:00:00	QQQ	ETF	213.97	214.18	213.96	213.97	6700.0
2020-04-20 05:30:00	QQQ	ETF	213.98	214.09	213.41	213.41	11744.0
2020-04-20 06:00:00	QQQ	ETF	213.46	213.53	212.5	212.62	37120.0
2020-04-20 06:30:00	QQQ	ETF	212.83	213.02	212.67	213.0	23167.0
2020-04-20 07:00:00	QQQ	ETF	212.98	213.3	212.48	212.62	107266.0
2020-04-20 07:30:00	QQQ	ETF	212.6	213.04	212.32	212.7	104655.0
2020-04-20 08:00:00	QQQ	ETF	212.9096	215.52	212.4396	213.04	173962.0
2020-04-20 08:30:00	QQQ	ETF	213.01	213.09	212.73	212.96	318614.0
2020-04-20 09:00:00	QQQ	ETF	212.86	213.57	212.6	213.27	375056.0
2020-04-20 09:30:00	QQQ	ETF	213.27	214.42	213.09	213.34	5430717.0
2020-04-20 10:00:00	QQQ	ETF	213.34	214.75	213.13	214.5	2579243.0
2020-04-20 10:30:00	QQQ	ETF	214.49	215.44	214.33	215.2	2593830.0
2020-04-20 11:00:00	QQQ	ETF	215.2	215.81	214.86	215.23	2406611.0
2020-04-20 11:30:00	QQQ	ETF	215.23	215.88	214.91	215.605	1755122.0
2020-04-20 12:00:00	QQQ	ETF	215.6	215.66	215.02	215.14	1375588.0
2020-04-20 12:30:00	QQQ	ETF	215.1455	215.6444	215.14	215.3	1153501.0

> showing 50 of 21,433 rows — these rows as CSV

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