PREVIEW / etf_30min / 2020-04-14

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-14.parquet
  size:    582 KB
  rows:    21,464

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-14 04:00:00	SPY	ETF	279.27	279.3	278.63	278.91	73092.0
2020-04-14 04:30:00	SPY	ETF	278.93	279.22	278.51	278.64	13217.0
2020-04-14 05:00:00	SPY	ETF	278.71	279.6	278.61	279.5	80030.0
2020-04-14 05:30:00	SPY	ETF	279.49	279.74	279.13	279.23	20975.0
2020-04-14 06:00:00	SPY	ETF	279.13	279.46	278.97	279.35	59030.0
2020-04-14 06:30:00	SPY	ETF	279.4	279.48	278.45	279.0	192863.0
2020-04-14 07:00:00	SPY	ETF	278.9	279.31	278.52	278.97	325936.0
2020-04-14 07:30:00	SPY	ETF	278.97	280.11	278.84	279.7	376247.0
2020-04-14 08:00:00	SPY	ETF	279.66	280.86	278.53	280.3	677437.0
2020-04-14 08:30:00	SPY	ETF	280.31	280.75	279.74	280.45	411999.0
2020-04-14 09:00:00	SPY	ETF	280.46	281.47	280.41	280.94	763954.0
2020-04-14 09:30:00	SPY	ETF	280.98	282.87	279.91	282.84	14870326.0
2020-04-14 10:00:00	SPY	ETF	282.86	283.79	282.34	283.02	10631409.0
2020-04-14 10:30:00	SPY	ETF	283.01	283.1	281.56	281.573	10371003.0
2020-04-14 11:00:00	SPY	ETF	281.58	282.09	280.1	280.8	11279433.0
2020-04-14 11:30:00	SPY	ETF	280.8	281.74	280.79	281.161	7375837.0
2020-04-14 12:00:00	SPY	ETF	281.19	283.25	281.19	282.77	7250584.0
2020-04-14 12:30:00	SPY	ETF	282.79	283.285	282.53	282.905	8566635.0
2020-04-14 13:00:00	SPY	ETF	282.9	283.02	282.3	282.805	5107849.0
2020-04-14 13:30:00	SPY	ETF	282.8199	284.0	282.8043	283.73	5496198.0
2020-04-14 14:00:00	SPY	ETF	283.75	284.3	283.28	283.79	6618668.0
2020-04-14 14:30:00	SPY	ETF	283.8	284.1	283.36	283.935	5976903.0
2020-04-14 15:00:00	SPY	ETF	283.94	283.95	282.55	283.59	9375119.0
2020-04-14 15:30:00	SPY	ETF	283.6	284.9	283.42	283.87	18093380.0
2020-04-14 16:00:00	SPY	ETF	283.89	284.55	283.0341	284.39	6035922.0
2020-04-14 16:30:00	SPY	ETF	284.39	284.6	283.79	284.56	671023.0
2020-04-14 17:00:00	SPY	ETF	284.57	284.67	283.79	284.61	1075211.0
2020-04-14 17:30:00	SPY	ETF	284.64	284.68	283.79	284.63	179819.0
2020-04-14 18:00:00	SPY	ETF	284.63	284.63	283.84	284.35	261429.0
2020-04-14 18:30:00	SPY	ETF	284.35	284.36	283.95	283.99	77624.0
2020-04-14 19:00:00	SPY	ETF	283.98	284.19	283.42	283.46	183895.0
2020-04-14 19:30:00	SPY	ETF	283.45	283.75	283.25	283.4	108747.0
2020-04-14 04:00:00	QQQ	ETF	205.9	206.0	205.65	205.94	23961.0
2020-04-14 04:30:00	QQQ	ETF	205.93	206.16	205.55	205.65	28560.0
2020-04-14 05:00:00	QQQ	ETF	205.64	206.31	205.64	206.31	8368.0
2020-04-14 05:30:00	QQQ	ETF	206.25	206.34	206.1	206.16	9654.0
2020-04-14 06:00:00	QQQ	ETF	206.12	206.33	205.99	206.33	13138.0
2020-04-14 06:30:00	QQQ	ETF	206.3	206.35	205.67	205.97	56049.0
2020-04-14 07:00:00	QQQ	ETF	205.91	206.13	205.64	205.94	81446.0
2020-04-14 07:30:00	QQQ	ETF	205.9	206.72	205.72	206.63	157100.0
2020-04-14 08:00:00	QQQ	ETF	205.7601	207.15	203.0744	207.0	1223772.0
2020-04-14 08:30:00	QQQ	ETF	207.0	207.25	206.65	207.09	277283.0
2020-04-14 09:00:00	QQQ	ETF	207.1	207.53	207.0501	207.14	221023.0
2020-04-14 09:30:00	QQQ	ETF	207.17	209.75	206.42	209.69	7804487.0
2020-04-14 10:00:00	QQQ	ETF	209.69	210.16	209.14	209.9401	6062474.0
2020-04-14 10:30:00	QQQ	ETF	209.94	210.115	209.4	209.415	3256146.0
2020-04-14 11:00:00	QQQ	ETF	209.43	209.86	208.51	209.02	3928231.0
2020-04-14 11:30:00	QQQ	ETF	209.02	209.75	209.02	209.445	2436563.0
2020-04-14 12:00:00	QQQ	ETF	209.48	210.96	209.48	210.685	3463191.0
2020-04-14 12:30:00	QQQ	ETF	210.68	211.38	210.6	211.13	2294697.0

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

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