PREVIEW / etf_30min / 2020-09-21

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-09-21.parquet
  size:    592 KB
  rows:    22,137

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-09-21 04:00:00	SPY	ETF	328.14	328.14	326.14	326.62	75372.0
2020-09-21 04:30:00	SPY	ETF	326.54	326.59	324.65	325.34	91285.0
2020-09-21 05:00:00	SPY	ETF	325.33	326.84	325.26	326.32	72742.0
2020-09-21 05:30:00	SPY	ETF	326.26	326.39	325.0	325.49	64998.0
2020-09-21 06:00:00	SPY	ETF	325.55	326.35	325.37	326.2	64075.0
2020-09-21 06:30:00	SPY	ETF	326.22	326.71	326.09	326.4	132800.0
2020-09-21 07:00:00	SPY	ETF	326.46	326.57	325.5	325.5	145946.0
2020-09-21 07:30:00	SPY	ETF	325.59	326.76	325.43	326.7	331781.0
2020-09-21 08:00:00	SPY	ETF	326.3499	331.04	325.23	325.35	505805.0
2020-09-21 08:30:00	SPY	ETF	325.41	325.83	324.81	325.8	451993.0
2020-09-21 09:00:00	SPY	ETF	325.75	326.05	325.17	325.68	798607.0
2020-09-21 09:30:00	SPY	ETF	325.7	326.5	323.67	325.24	10412341.0
2020-09-21 10:00:00	SPY	ETF	325.22	325.58	322.51	322.71	8885929.0
2020-09-21 10:30:00	SPY	ETF	322.7	323.159	321.73	322.7	9251167.0
2020-09-21 11:00:00	SPY	ETF	322.69	323.858	321.89	322.47	4946009.0
2020-09-21 11:30:00	SPY	ETF	322.46	323.82	321.895	323.62	5455932.0
2020-09-21 12:00:00	SPY	ETF	323.62	324.55	323.5	324.25	4032524.0
2020-09-21 12:30:00	SPY	ETF	324.27	324.54	323.005	323.27	3398290.0
2020-09-21 13:00:00	SPY	ETF	323.27	324.43	322.62	324.39	3992115.0
2020-09-21 13:30:00	SPY	ETF	324.4	324.8	323.14	323.64	4459010.0
2020-09-21 14:00:00	SPY	ETF	323.65	323.88	322.72	323.3	4457111.0
2020-09-21 14:30:00	SPY	ETF	323.28	323.5925	322.16	323.41	6820052.0
2020-09-21 15:00:00	SPY	ETF	323.42	325.39	323.305	324.9909	6393423.0
2020-09-21 15:30:00	SPY	ETF	324.99	327.09	324.52	327.0	13554012.0
2020-09-21 16:00:00	SPY	ETF	327.02	331.165	326.949	327.21	7328149.0
2020-09-21 16:30:00	SPY	ETF	327.25	327.85	326.97	327.32	859867.0
2020-09-21 17:00:00	SPY	ETF	327.39	327.43	326.95	326.96	245532.0
2020-09-21 17:30:00	SPY	ETF	326.96	327.11	326.9	327.04	85446.0
2020-09-21 18:00:00	SPY	ETF	327.05	327.5	326.95	327.3	379081.0
2020-09-21 18:30:00	SPY	ETF	327.29	327.54	327.2	327.47	12411.0
2020-09-21 19:00:00	SPY	ETF	327.45	327.47	327.22	327.46	14817.0
2020-09-21 19:30:00	SPY	ETF	327.46	328.2	327.46	328.1	96202.0
2020-09-21 04:00:00	QQQ	ETF	264.5	264.54	262.74	263.14	90868.0
2020-09-21 04:30:00	QQQ	ETF	263.14	263.21	261.79	262.19	88859.0
2020-09-21 05:00:00	QQQ	ETF	262.14	263.68	261.91	262.7	66401.0
2020-09-21 05:30:00	QQQ	ETF	262.86	262.94	261.39	262.02	58098.0
2020-09-21 06:00:00	QQQ	ETF	262.25	263.31	261.9	262.91	35760.0
2020-09-21 06:30:00	QQQ	ETF	262.94	263.52	262.68	263.26	34033.0
2020-09-21 07:00:00	QQQ	ETF	263.25	263.34	261.56	261.81	168338.0
2020-09-21 07:30:00	QQQ	ETF	261.78	263.58	261.7	263.39	202753.0
2020-09-21 08:00:00	QQQ	ETF	262.9399	266.44	261.7098	262.4	566691.0
2020-09-21 08:30:00	QQQ	ETF	262.3	262.91	261.88	262.72	316472.0
2020-09-21 09:00:00	QQQ	ETF	262.68	262.95	262.08	262.52	577251.0
2020-09-21 09:30:00	QQQ	ETF	262.52	264.6	261.25	263.6692	7167872.0
2020-09-21 10:00:00	QQQ	ETF	263.64	264.1	261.16	261.25	3605085.0
2020-09-21 10:30:00	QQQ	ETF	261.24	261.86	260.11	261.49	3745236.0
2020-09-21 11:00:00	QQQ	ETF	261.5	262.96	261.0	261.91	2709661.0
2020-09-21 11:30:00	QQQ	ETF	261.88	263.68	261.3	263.6055	2223355.0
2020-09-21 12:00:00	QQQ	ETF	263.6237	264.72	263.5	264.54	2821783.0
2020-09-21 12:30:00	QQQ	ETF	264.55	264.83	263.53	263.83	1934855.0

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

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