PREVIEW / etf_30min / 2021-03-02

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-03-02.parquet
  size:    629 KB
  rows:    24,015

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
2021-03-02 04:00:00	SPY	ETF	387.5	387.5	386.42	387.28	68556.0
2021-03-02 04:30:00	SPY	ETF	387.33	387.94	387.31	387.65	19151.0
2021-03-02 05:00:00	SPY	ETF	387.84	388.06	387.35	388.03	15984.0
2021-03-02 05:30:00	SPY	ETF	387.81	388.37	387.81	388.36	11625.0
2021-03-02 06:00:00	SPY	ETF	388.28	388.65	388.12	388.59	24211.0
2021-03-02 06:30:00	SPY	ETF	388.6	388.8	388.21	388.49	164246.0
2021-03-02 07:00:00	SPY	ETF	388.5	389.2	388.47	389.17	198877.0
2021-03-02 07:30:00	SPY	ETF	389.14	389.41	389.0	389.34	71369.0
2021-03-02 08:00:00	SPY	ETF	389.34	389.43	387.5	389.12	148759.0
2021-03-02 08:30:00	SPY	ETF	389.13	389.24	388.6	389.14	239300.0
2021-03-02 09:00:00	SPY	ETF	389.2	389.88	388.98	389.81	280911.0
2021-03-02 09:30:00	SPY	ETF	389.82	390.07	388.2	389.3	8911366.0
2021-03-02 10:00:00	SPY	ETF	389.31	389.72	387.53	387.55	5093765.0
2021-03-02 10:30:00	SPY	ETF	387.54	388.43	387.08	388.17	5041533.0
2021-03-02 11:00:00	SPY	ETF	388.13	388.39	386.95	388.0	5154252.0
2021-03-02 11:30:00	SPY	ETF	388.0	388.02	386.0	387.52	4347117.0
2021-03-02 12:00:00	SPY	ETF	387.52	388.59	387.21	388.23	3140307.0
2021-03-02 12:30:00	SPY	ETF	388.2219	389.09	388.1699	388.639	2112281.0
2021-03-02 13:00:00	SPY	ETF	388.6399	389.42	388.6399	389.1	1959592.0
2021-03-02 13:30:00	SPY	ETF	389.11	389.74	389.07	389.23	2531245.0
2021-03-02 14:00:00	SPY	ETF	389.2281	389.54	388.3	388.32	3200165.0
2021-03-02 14:30:00	SPY	ETF	388.35	389.35	388.15	389.05	2578449.0
2021-03-02 15:00:00	SPY	ETF	389.03	389.36	387.84	387.85	3709382.0
2021-03-02 15:30:00	SPY	ETF	387.86	388.22	386.3	386.55	8998809.0
2021-03-02 16:00:00	SPY	ETF	386.56	387.2	386.4	386.93	4334283.0
2021-03-02 16:30:00	SPY	ETF	386.95	387.07	386.35	386.4	496205.0
2021-03-02 17:00:00	SPY	ETF	386.4	386.48	386.25	386.39	31589.0
2021-03-02 17:30:00	SPY	ETF	386.44	386.57	386.25	386.57	123064.0
2021-03-02 18:00:00	SPY	ETF	386.57	387.28	386.55	387.21	158360.0
2021-03-02 18:30:00	SPY	ETF	386.54	387.6	386.54	387.4	88386.0
2021-03-02 19:00:00	SPY	ETF	387.4	387.57	387.2	387.54	23969.0
2021-03-02 19:30:00	SPY	ETF	387.57	387.9	387.5	387.78	52663.0
2021-03-02 04:00:00	QQQ	ETF	321.21	321.63	320.91	321.6	69675.0
2021-03-02 04:30:00	QQQ	ETF	321.64	322.2	321.59	321.76	27045.0
2021-03-02 05:00:00	QQQ	ETF	321.81	322.41	321.5	322.29	18548.0
2021-03-02 05:30:00	QQQ	ETF	322.19	322.63	322.1	322.52	12160.0
2021-03-02 06:00:00	QQQ	ETF	322.43	322.92	322.33	322.87	10052.0
2021-03-02 06:30:00	QQQ	ETF	322.78	322.85	322.48	322.55	26295.0
2021-03-02 07:00:00	QQQ	ETF	322.6	323.4	322.52	323.3	95527.0
2021-03-02 07:30:00	QQQ	ETF	323.3	323.59	323.04	323.59	88187.0
2021-03-02 08:00:00	QQQ	ETF	322.7904	323.8	321.5	323.43	155676.0
2021-03-02 08:30:00	QQQ	ETF	323.39	323.4	322.63	323.29	283095.0
2021-03-02 09:00:00	QQQ	ETF	323.33	324.31	323.15	324.18	278268.0
2021-03-02 09:30:00	QQQ	ETF	324.2	324.33	321.31	322.31	5541374.0
2021-03-02 10:00:00	QQQ	ETF	322.31	322.99	320.77	320.77	3497427.0
2021-03-02 10:30:00	QQQ	ETF	320.78	321.638	320.21	321.27	2972531.0
2021-03-02 11:00:00	QQQ	ETF	321.24	321.84	319.65	320.72	3029291.0
2021-03-02 11:30:00	QQQ	ETF	320.72	320.75	319.38	320.355	2611338.0
2021-03-02 12:00:00	QQQ	ETF	320.37	321.22	319.95	320.7798	2356266.0
2021-03-02 12:30:00	QQQ	ETF	320.77	321.705	320.72	321.05	1489639.0

> showing 50 of 24,015 rows — these rows as CSV

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