PREVIEW / etf_30min / 2020-09-25

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-09-25.parquet
  size:    547 KB
  rows:    20,056

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-25 04:00:00	SPY	ETF	323.8	323.99	323.26	323.51	22594.0
2020-09-25 04:30:00	SPY	ETF	323.37	323.96	323.37	323.95	12927.0
2020-09-25 05:00:00	SPY	ETF	324.12	324.21	323.41	323.64	22392.0
2020-09-25 05:30:00	SPY	ETF	323.39	323.46	322.5	323.04	39415.0
2020-09-25 06:00:00	SPY	ETF	322.98	323.24	322.0	322.03	21367.0
2020-09-25 06:30:00	SPY	ETF	322.0	322.36	321.17	321.26	99431.0
2020-09-25 07:00:00	SPY	ETF	321.29	321.9	320.66	321.65	303954.0
2020-09-25 07:30:00	SPY	ETF	321.46	322.76	321.21	322.67	272870.0
2020-09-25 08:00:00	SPY	ETF	321.0	325.4	320.81	322.78	266508.0
2020-09-25 08:30:00	SPY	ETF	322.71	323.09	322.25	323.07	233153.0
2020-09-25 09:00:00	SPY	ETF	323.05	323.3	322.53	322.53	441909.0
2020-09-25 09:30:00	SPY	ETF	322.58	323.69	322.15	323.52	6572235.0
2020-09-25 10:00:00	SPY	ETF	323.515	324.26	321.64	324.08	5897286.0
2020-09-25 10:30:00	SPY	ETF	324.08	325.29	323.68	324.82	4178562.0
2020-09-25 11:00:00	SPY	ETF	324.82	325.86	324.21	325.42	3121512.0
2020-09-25 11:30:00	SPY	ETF	325.43	325.73	324.3	324.33	3412559.0
2020-09-25 12:00:00	SPY	ETF	324.33	325.81	324.3299	325.065	3456313.0
2020-09-25 12:30:00	SPY	ETF	325.06	325.78	324.75	325.68	1877582.0
2020-09-25 13:00:00	SPY	ETF	325.69	326.4	325.415	326.209	3332259.0
2020-09-25 13:30:00	SPY	ETF	326.1919	327.11	326.09	326.92	2964348.0
2020-09-25 14:00:00	SPY	ETF	326.92	327.76	326.86	327.61	2826555.0
2020-09-25 14:30:00	SPY	ETF	327.61	328.14	327.23	328.09	3680694.0
2020-09-25 15:00:00	SPY	ETF	328.08	329.58	328.0	329.3	5473852.0
2020-09-25 15:30:00	SPY	ETF	329.31	329.33	328.16	328.69	12544656.0
2020-09-25 16:00:00	SPY	ETF	328.69	328.91	328.3	328.82	6910604.0
2020-09-25 16:30:00	SPY	ETF	328.82	328.94	328.4	328.49	1258615.0
2020-09-25 17:00:00	SPY	ETF	328.46	328.73	328.4	328.41	528374.0
2020-09-25 17:30:00	SPY	ETF	328.41	328.41	328.29	328.29	30843.0
2020-09-25 18:00:00	SPY	ETF	328.35	328.36	328.08	328.3	28713.0
2020-09-25 18:30:00	SPY	ETF	328.29	328.3	328.23	328.3	7883.0
2020-09-25 19:00:00	SPY	ETF	328.25	328.38	328.15	328.2	10876.0
2020-09-25 19:30:00	SPY	ETF	328.24	328.3	328.03	328.06	25405.0
2020-09-25 04:00:00	QQQ	ETF	265.6	265.79	264.97	265.34	39188.0
2020-09-25 04:30:00	QQQ	ETF	265.5	265.96	265.5	265.96	15800.0
2020-09-25 05:00:00	QQQ	ETF	266.0	266.04	265.4	265.49	3721.0
2020-09-25 05:30:00	QQQ	ETF	265.33	265.33	264.62	265.15	16701.0
2020-09-25 06:00:00	QQQ	ETF	265.08	265.55	264.41	264.43	25066.0
2020-09-25 06:30:00	QQQ	ETF	264.62	264.78	263.92	264.21	29170.0
2020-09-25 07:00:00	QQQ	ETF	264.21	265.11	263.92	264.78	137033.0
2020-09-25 07:30:00	QQQ	ETF	264.7	266.0	264.26	265.73	165479.0
2020-09-25 08:00:00	QQQ	ETF	264.2199	267.24	263.9001	265.97	232621.0
2020-09-25 08:30:00	QQQ	ETF	266.08	266.48	265.39	266.29	381803.0
2020-09-25 09:00:00	QQQ	ETF	266.26	266.79	265.83	265.88	337176.0
2020-09-25 09:30:00	QQQ	ETF	265.82	266.29	264.2999	266.08	4175111.0
2020-09-25 10:00:00	QQQ	ETF	266.06	267.11	264.35	266.89	3105313.0
2020-09-25 10:30:00	QQQ	ETF	266.89	268.079	266.654	267.58	2480572.0
2020-09-25 11:00:00	QQQ	ETF	267.61	269.17	267.09	268.71	2118549.0
2020-09-25 11:30:00	QQQ	ETF	268.73	268.94	267.51	267.57	2165363.0
2020-09-25 12:00:00	QQQ	ETF	267.56	269.18	267.55	268.3001	1971046.0
2020-09-25 12:30:00	QQQ	ETF	268.37	268.81	267.87	268.735	1182492.0

> showing 50 of 20,056 rows — these rows as CSV

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