PREVIEW / etf_30min / 2020-03-11

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-11.parquet
  size:    609 KB
  rows:    22,309

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-11 04:00:00	SPY	ETF	281.3	282.27	279.56	279.76	98446.0
2020-03-11 04:30:00	SPY	ETF	279.5	284.06	279.5	283.05	63316.0
2020-03-11 05:00:00	SPY	ETF	283.18	283.18	281.76	282.94	27907.0
2020-03-11 05:30:00	SPY	ETF	282.77	282.99	280.68	281.79	49949.0
2020-03-11 06:00:00	SPY	ETF	281.7	281.81	279.81	280.27	99011.0
2020-03-11 06:30:00	SPY	ETF	280.46	282.51	280.22	281.38	172036.0
2020-03-11 07:00:00	SPY	ETF	281.49	281.74	279.79	279.92	506117.0
2020-03-11 07:30:00	SPY	ETF	279.85	280.37	278.58	279.85	602812.0
2020-03-11 08:00:00	SPY	ETF	281.35	281.66	278.58	279.0	916330.0
2020-03-11 08:30:00	SPY	ETF	278.9	288.42	277.0	277.11	1511686.0
2020-03-11 09:00:00	SPY	ETF	277.06	280.8	277.0	280.71	1509933.0
2020-03-11 09:30:00	SPY	ETF	280.7	281.94	279.07	280.47	19200459.0
2020-03-11 10:00:00	SPY	ETF	280.45	281.48	278.5	278.85	17288816.0
2020-03-11 10:30:00	SPY	ETF	278.83	279.8	277.23	278.505	14583942.0
2020-03-11 11:00:00	SPY	ETF	278.53	279.4261	276.16	276.67	15417204.0
2020-03-11 11:30:00	SPY	ETF	276.68	278.41	276.26	277.94	13056255.0
2020-03-11 12:00:00	SPY	ETF	277.95	280.74	277.11	278.19	15049250.0
2020-03-11 12:30:00	SPY	ETF	278.14	278.5	275.57	276.52	15489902.0
2020-03-11 13:00:00	SPY	ETF	276.49	276.81	274.84	276.56	12947157.0
2020-03-11 13:30:00	SPY	ETF	276.6	277.04	274.7	275.97	9986374.0
2020-03-11 14:00:00	SPY	ETF	275.96	276.43	273.6	273.93	13091519.0
2020-03-11 14:30:00	SPY	ETF	273.9	276.0	273.34	273.66	18838388.0
2020-03-11 15:00:00	SPY	ETF	273.7	274.22	270.88	272.86	26191543.0
2020-03-11 15:30:00	SPY	ETF	272.86	276.33	272.4	274.36	39914573.0
2020-03-11 16:00:00	SPY	ETF	274.36	279.0514	273.9	274.72	14326579.0
2020-03-11 16:30:00	SPY	ETF	274.72	275.56	274.32	274.7	1328870.0
2020-03-11 17:00:00	SPY	ETF	274.61	274.93	273.75	273.75	577300.0
2020-03-11 17:30:00	SPY	ETF	273.81	274.25	273.74	274.2	269805.0
2020-03-11 18:00:00	SPY	ETF	274.22	277.4	274.04	277.34	855177.0
2020-03-11 18:30:00	SPY	ETF	277.31	277.87	275.88	277.26	313413.0
2020-03-11 19:00:00	SPY	ETF	277.24	277.24	274.86	275.18	214406.0
2020-03-11 19:30:00	SPY	ETF	275.2	275.52	273.33	273.9	400617.0
2020-03-11 04:00:00	QQQ	ETF	199.61	200.04	197.9	198.23	66020.0
2020-03-11 04:30:00	QQQ	ETF	197.97	201.34	197.97	200.65	68478.0
2020-03-11 05:00:00	QQQ	ETF	200.63	200.76	199.83	200.61	23001.0
2020-03-11 05:30:00	QQQ	ETF	200.6	200.6	199.03	199.88	41920.0
2020-03-11 06:00:00	QQQ	ETF	199.86	199.86	198.47	198.81	29367.0
2020-03-11 06:30:00	QQQ	ETF	198.92	200.33	198.7	199.66	56209.0
2020-03-11 07:00:00	QQQ	ETF	199.73	200.0	198.73	198.9	212698.0
2020-03-11 07:30:00	QQQ	ETF	198.83	199.16	197.93	198.7	306669.0
2020-03-11 08:00:00	QQQ	ETF	198.7	200.0	197.78	198.0	463631.0
2020-03-11 08:30:00	QQQ	ETF	198.1	198.3	197.1	197.28	358568.0
2020-03-11 09:00:00	QQQ	ETF	197.27	204.11	197.21	199.31	477006.0
2020-03-11 09:30:00	QQQ	ETF	199.32	200.59	198.41	199.7	6149889.0
2020-03-11 10:00:00	QQQ	ETF	199.69	200.75	198.45	198.63	5899250.0
2020-03-11 10:30:00	QQQ	ETF	198.6	199.18	197.44	198.13	5125392.0
2020-03-11 11:00:00	QQQ	ETF	198.16	198.74	196.88	197.16	4379202.0
2020-03-11 11:30:00	QQQ	ETF	197.22	198.14	196.91	197.73	3378067.0
2020-03-11 12:00:00	QQQ	ETF	197.77	199.6499	197.17	198.05	3878740.0
2020-03-11 12:30:00	QQQ	ETF	198.05	198.35	196.18	196.7	4002272.0

> showing 50 of 22,309 rows — these rows as CSV

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