PREVIEW / etf_30min / 2020-05-14

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-05-14.parquet
  size:    556 KB
  rows:    20,705

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-05-14 04:00:00	SPY	ETF	281.36	281.55	280.77	281.36	50624.0
2020-05-14 04:30:00	SPY	ETF	281.6	281.65	280.95	281.22	49738.0
2020-05-14 05:00:00	SPY	ETF	281.22	281.76	281.03	281.64	54521.0
2020-05-14 05:30:00	SPY	ETF	281.62	282.1	281.54	282.1	58340.0
2020-05-14 06:00:00	SPY	ETF	281.98	281.98	280.74	281.23	62497.0
2020-05-14 06:30:00	SPY	ETF	281.38	281.73	281.0	281.46	127633.0
2020-05-14 07:00:00	SPY	ETF	281.5	281.7	280.46	280.46	213702.0
2020-05-14 07:30:00	SPY	ETF	280.47	280.77	279.81	279.99	796186.0
2020-05-14 08:00:00	SPY	ETF	279.99	282.33	279.08	279.42	807718.0
2020-05-14 08:30:00	SPY	ETF	279.63	279.86	278.1	278.94	1172227.0
2020-05-14 09:00:00	SPY	ETF	278.9	279.4	278.4101	278.94	889436.0
2020-05-14 09:30:00	SPY	ETF	278.95	279.78	272.99	276.89	15736192.0
2020-05-14 10:00:00	SPY	ETF	276.89	278.28	276.37	277.31	10624179.0
2020-05-14 10:30:00	SPY	ETF	277.3	280.62	277.29	279.87	11078074.0
2020-05-14 11:00:00	SPY	ETF	279.87	281.62	279.65	279.918	10107232.0
2020-05-14 11:30:00	SPY	ETF	279.92	280.8	279.02	279.7698	8076419.0
2020-05-14 12:00:00	SPY	ETF	279.785	281.43	279.4	280.8	5521008.0
2020-05-14 12:30:00	SPY	ETF	280.8	282.64	280.62	282.4057	5565083.0
2020-05-14 13:00:00	SPY	ETF	282.42	283.34	281.8201	283.3	4684457.0
2020-05-14 13:30:00	SPY	ETF	283.3	283.65	282.0033	282.09	5287955.0
2020-05-14 14:00:00	SPY	ETF	282.08	282.62	281.35	282.565	5248555.0
2020-05-14 14:30:00	SPY	ETF	282.56	282.7	281.05	282.18	4334385.0
2020-05-14 15:00:00	SPY	ETF	282.18	284.1	281.93	283.89	7863898.0
2020-05-14 15:30:00	SPY	ETF	283.89	285.11	282.84	285.05	15978586.0
2020-05-14 16:00:00	SPY	ETF	285.05	285.73	284.96	285.06	5624103.0
2020-05-14 16:30:00	SPY	ETF	285.06	285.37	284.8	285.17	463762.0
2020-05-14 17:00:00	SPY	ETF	285.05	285.2	284.91	284.99	120617.0
2020-05-14 17:30:00	SPY	ETF	284.91	285.19	284.84	285.19	200329.0
2020-05-14 18:00:00	SPY	ETF	285.07	285.22	284.6	285.01	156421.0
2020-05-14 18:30:00	SPY	ETF	284.95	284.98	284.56	284.75	113199.0
2020-05-14 19:00:00	SPY	ETF	284.75	285.25	284.61	285.21	66369.0
2020-05-14 19:30:00	SPY	ETF	285.23	285.8	285.23	285.68	165537.0
2020-05-14 04:00:00	QQQ	ETF	219.67	219.79	219.24	219.62	23674.0
2020-05-14 04:30:00	QQQ	ETF	219.85	220.01	219.4	219.87	32621.0
2020-05-14 05:00:00	QQQ	ETF	219.71	220.24	219.71	220.15	25026.0
2020-05-14 05:30:00	QQQ	ETF	220.2	220.58	220.14	220.51	21979.0
2020-05-14 06:00:00	QQQ	ETF	220.44	220.44	219.42	219.73	9104.0
2020-05-14 06:30:00	QQQ	ETF	219.9	220.03	219.36	219.43	10034.0
2020-05-14 07:00:00	QQQ	ETF	219.63	219.82	218.65	218.65	95166.0
2020-05-14 07:30:00	QQQ	ETF	218.67	219.02	218.01	218.11	142088.0
2020-05-14 08:00:00	QQQ	ETF	218.1	220.35	217.53	217.92	238768.0
2020-05-14 08:30:00	QQQ	ETF	217.99	218.27	217.0198	217.98	292064.0
2020-05-14 09:00:00	QQQ	ETF	218.0	218.25	217.5105	218.05	344672.0
2020-05-14 09:30:00	QQQ	ETF	218.09	219.09	216.13	216.54	6072321.0
2020-05-14 10:00:00	QQQ	ETF	216.6	217.71	216.06	216.09	4145803.0
2020-05-14 10:30:00	QQQ	ETF	216.09	217.97	215.99	217.3206	3981191.0
2020-05-14 11:00:00	QQQ	ETF	217.35	219.07	217.26	217.86	3515948.0
2020-05-14 11:30:00	QQQ	ETF	217.84	218.79	217.1601	217.31	4534989.0
2020-05-14 12:00:00	QQQ	ETF	217.345	218.48	217.04	218.03	2541245.0
2020-05-14 12:30:00	QQQ	ETF	218.02	219.32	217.81	219.18	2223690.0

> showing 50 of 20,705 rows — these rows as CSV

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