PREVIEW / etf_30min / 2020-04-07

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-07.parquet
  size:    595 KB
  rows:    22,168

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-07 04:00:00	SPY	ETF	270.75	272.26	270.48	271.99	155943.0
2020-04-07 04:30:00	SPY	ETF	271.97	271.97	270.71	270.75	88172.0
2020-04-07 05:00:00	SPY	ETF	270.78	272.2	270.71	271.7	120907.0
2020-04-07 05:30:00	SPY	ETF	271.6	272.08	271.32	271.77	71686.0
2020-04-07 06:00:00	SPY	ETF	271.81	274.64	271.62	273.61	461101.0
2020-04-07 06:30:00	SPY	ETF	273.57	274.11	272.73	274.02	434320.0
2020-04-07 07:00:00	SPY	ETF	274.02	274.07	272.7	273.15	836952.0
2020-04-07 07:30:00	SPY	ETF	273.15	273.23	271.92	272.04	868455.0
2020-04-07 08:00:00	SPY	ETF	272.04	274.05	263.22	271.77	1208309.0
2020-04-07 08:30:00	SPY	ETF	271.81	273.65	271.78	273.47	1567173.0
2020-04-07 09:00:00	SPY	ETF	273.47	274.43	272.86	274.23	2948492.0
2020-04-07 09:30:00	SPY	ETF	274.21	275.03	271.83	273.75	28495374.0
2020-04-07 10:00:00	SPY	ETF	273.76	273.98	269.28	269.64	16836301.0
2020-04-07 10:30:00	SPY	ETF	269.66	271.0699	268.02	269.03	11070628.0
2020-04-07 11:00:00	SPY	ETF	269.015	271.26	268.3	271.167	11337601.0
2020-04-07 11:30:00	SPY	ETF	271.16	272.54	271.03	271.4873	9259015.0
2020-04-07 12:00:00	SPY	ETF	271.5	273.92	271.44	273.13	10411824.0
2020-04-07 12:30:00	SPY	ETF	273.14	273.27	272.08	272.65	7979687.0
2020-04-07 13:00:00	SPY	ETF	272.64	273.25	271.47	272.15	6868711.0
2020-04-07 13:30:00	SPY	ETF	272.17	272.23	270.53	270.78	7560280.0
2020-04-07 14:00:00	SPY	ETF	270.78	270.91	268.52	269.45	9427900.0
2020-04-07 14:30:00	SPY	ETF	269.4498	269.93	266.15	266.71	12955059.0
2020-04-07 15:00:00	SPY	ETF	266.725	269.0475	265.62	265.9879	17073653.0
2020-04-07 15:30:00	SPY	ETF	265.99	269.86	264.89	265.1	30562741.0
2020-04-07 16:00:00	SPY	ETF	265.1	269.499	263.65	264.4	7298528.0
2020-04-07 16:30:00	SPY	ETF	264.4	274.39	263.67	263.82	2219450.0
2020-04-07 17:00:00	SPY	ETF	263.82	265.13	263.64	263.84	770472.0
2020-04-07 17:30:00	SPY	ETF	263.85	264.16	263.8	264.16	79421.0
2020-04-07 18:00:00	SPY	ETF	264.13	264.41	263.0	263.21	401650.0
2020-04-07 18:30:00	SPY	ETF	263.21	264.05	262.89	263.43	853809.0
2020-04-07 19:00:00	SPY	ETF	263.43	264.92	263.29	264.8	364669.0
2020-04-07 19:30:00	SPY	ETF	264.9	266.04	264.68	265.22	618197.0
2020-04-07 20:00:00	SPY	ETF	265.19	265.19	265.14	265.14	700.0
2020-04-07 04:00:00	QQQ	ETF	200.18	201.18	199.91	201.03	180347.0
2020-04-07 04:30:00	QQQ	ETF	200.93	200.93	200.08	200.17	35735.0
2020-04-07 05:00:00	QQQ	ETF	200.28	200.94	200.0	200.6	35097.0
2020-04-07 05:30:00	QQQ	ETF	200.6	200.83	200.33	200.5	43621.0
2020-04-07 06:00:00	QQQ	ETF	200.51	202.56	200.51	201.82	106668.0
2020-04-07 06:30:00	QQQ	ETF	201.77	202.43	201.46	202.32	86957.0
2020-04-07 07:00:00	QQQ	ETF	202.3	202.37	201.5	201.68	197755.0
2020-04-07 07:30:00	QQQ	ETF	201.68	201.88	201.05	201.16	188889.0
2020-04-07 08:00:00	QQQ	ETF	201.13	202.31	194.5	201.05	401847.0
2020-04-07 08:30:00	QQQ	ETF	201.05	202.15	201.0	202.14	309274.0
2020-04-07 09:00:00	QQQ	ETF	202.02	202.59	201.62	202.22	334428.0
2020-04-07 09:30:00	QQQ	ETF	202.18	202.66	200.16	201.6181	9169449.0
2020-04-07 10:00:00	QQQ	ETF	201.61	201.79	198.2091	198.43	6832951.0
2020-04-07 10:30:00	QQQ	ETF	198.43	199.37	196.98	197.74	5442019.0
2020-04-07 11:00:00	QQQ	ETF	197.72	199.15	197.11	199.1	3920716.0
2020-04-07 11:30:00	QQQ	ETF	199.09	200.08	199.02	199.5097	3168361.0
2020-04-07 12:00:00	QQQ	ETF	199.51	201.54	199.45	201.02	3918778.0

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

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