PREVIEW / etf_30min / 2020-03-12

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-12.parquet
  size:    674 KB
  rows:    25,016

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-03-12 04:00:00	SPY	ETF	263.95	265.0	262.75	262.75	140183.0
2020-03-12 04:30:00	SPY	ETF	262.74	263.18	261.02	261.52	108499.0
2020-03-12 05:00:00	SPY	ETF	261.43	261.59	260.77	260.8	111209.0
2020-03-12 05:30:00	SPY	ETF	260.85	263.68	260.73	262.38	138627.0
2020-03-12 06:00:00	SPY	ETF	262.3	262.37	260.73	261.65	106663.0
2020-03-12 06:30:00	SPY	ETF	261.25	262.96	261.04	262.96	123215.0
2020-03-12 07:00:00	SPY	ETF	262.81	262.96	261.15	261.54	511497.0
2020-03-12 07:30:00	SPY	ETF	261.56	262.0	260.78	260.9	625539.0
2020-03-12 08:00:00	SPY	ETF	265.0	267.41	258.38	259.8	1633726.0
2020-03-12 08:30:00	SPY	ETF	259.81	261.0	255.6	256.74	2497188.0
2020-03-12 09:00:00	SPY	ETF	256.6	256.79	254.32	255.99	3312703.0
2020-03-12 09:30:00	SPY	ETF	256.0	259.12	249.55	258.62	27413557.0
2020-03-12 10:00:00	SPY	ETF	258.6	258.64	253.24	256.19	33442744.0
2020-03-12 10:30:00	SPY	ETF	256.19	258.79	255.53	257.76	24442410.0
2020-03-12 11:00:00	SPY	ETF	257.75	257.8	253.05	254.25	18156730.0
2020-03-12 11:30:00	SPY	ETF	254.25	255.43	251.13	252.81	18495973.0
2020-03-12 12:00:00	SPY	ETF	252.79	254.56	250.36	253.39	18473003.0
2020-03-12 12:30:00	SPY	ETF	253.38	262.22	250.79	260.0	27483250.0
2020-03-12 13:00:00	SPY	ETF	259.99	266.66	257.2	258.595	43793123.0
2020-03-12 13:30:00	SPY	ETF	258.58	259.75	253.2	257.12	25612121.0
2020-03-12 14:00:00	SPY	ETF	257.1	258.0	252.42	253.4	18910647.0
2020-03-12 14:30:00	SPY	ETF	253.42	255.9402	251.87	252.07	14842628.0
2020-03-12 15:00:00	SPY	ETF	252.08	255.15	250.79	250.9998	24162567.0
2020-03-12 15:30:00	SPY	ETF	251.005	254.98	247.68	248.1	51441837.0
2020-03-12 16:00:00	SPY	ETF	248.1	249.64	246.35	247.45	13833259.0
2020-03-12 16:30:00	SPY	ETF	247.42	264.5	245.35	246.04	2757849.0
2020-03-12 17:00:00	SPY	ETF	246.0	248.11	243.88	244.1	12134447.0
2020-03-12 17:30:00	SPY	ETF	243.93	248.11	242.0	243.26	1904998.0
2020-03-12 18:00:00	SPY	ETF	243.5	248.06	242.91	245.52	859465.0
2020-03-12 18:30:00	SPY	ETF	245.39	249.26	245.32	247.1	2906145.0
2020-03-12 19:00:00	SPY	ETF	247.56	248.21	245.44	246.4	288736.0
2020-03-12 19:30:00	SPY	ETF	246.4	246.42	243.94	244.85	391330.0
2020-03-12 04:00:00	QQQ	ETF	187.69	188.48	186.84	186.84	118499.0
2020-03-12 04:30:00	QQQ	ETF	186.81	187.32	185.72	186.13	77797.0
2020-03-12 05:00:00	QQQ	ETF	186.14	186.17	185.68	185.68	39665.0
2020-03-12 05:30:00	QQQ	ETF	185.66	187.08	185.64	186.62	70605.0
2020-03-12 06:00:00	QQQ	ETF	186.39	186.49	185.61	186.03	31142.0
2020-03-12 06:30:00	QQQ	ETF	185.9	186.75	185.7	186.75	35649.0
2020-03-12 07:00:00	QQQ	ETF	186.8	186.8	185.7	185.8	208879.0
2020-03-12 07:30:00	QQQ	ETF	185.8	186.17	184.89	184.89	292290.0
2020-03-12 08:00:00	QQQ	ETF	184.9	189.55	183.17	183.46	714023.0
2020-03-12 08:30:00	QQQ	ETF	184.03	184.62	182.74	183.57	395048.0
2020-03-12 09:00:00	QQQ	ETF	183.57	183.81	181.88	181.9	833904.0
2020-03-12 09:30:00	QQQ	ETF	182.09	184.98	178.82	184.81	10576996.0
2020-03-12 10:00:00	QQQ	ETF	184.79	185.4	182.01	184.04	11243877.0
2020-03-12 10:30:00	QQQ	ETF	184.08	185.9	183.33	185.12	8246961.0
2020-03-12 11:00:00	QQQ	ETF	185.13	185.14	181.67	182.24	6443366.0
2020-03-12 11:30:00	QQQ	ETF	182.24	183.02	179.78	180.79	7377903.0
2020-03-12 12:00:00	QQQ	ETF	180.77	181.79	178.85	181.11	7878572.0
2020-03-12 12:30:00	QQQ	ETF	181.1	186.77	179.75	185.35	8065844.0

> showing 50 of 25,016 rows — these rows as CSV

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