PREVIEW / etf_30min / 2022-03-14

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-03-14.parquet
  size:    684 KB
  rows:    27,407

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
2022-03-14 04:00:00	SPY	ETF	422.7	423.98	422.02	422.09	51472.0
2022-03-14 04:30:00	SPY	ETF	421.97	422.86	421.79	422.44	33771.0
2022-03-14 05:00:00	SPY	ETF	423.0	423.59	422.24	422.48	32216.0
2022-03-14 05:30:00	SPY	ETF	422.51	425.05	422.51	424.59	48453.0
2022-03-14 06:00:00	SPY	ETF	424.61	424.63	423.44	423.62	29706.0
2022-03-14 06:30:00	SPY	ETF	423.96	424.31	423.25	424.08	28583.0
2022-03-14 07:00:00	SPY	ETF	424.04	424.05	421.61	421.93	210939.0
2022-03-14 07:30:00	SPY	ETF	421.88	422.27	420.68	420.8	205510.0
2022-03-14 08:00:00	SPY	ETF	423.34	424.5704	420.54	421.04	247044.0
2022-03-14 08:30:00	SPY	ETF	420.98	422.42	420.82	422.2699	542728.0
2022-03-14 09:00:00	SPY	ETF	422.22	422.24	420.88	420.9	546299.0
2022-03-14 09:30:00	SPY	ETF	420.89	421.97	419.11	421.33	8504222.0
2022-03-14 10:00:00	SPY	ETF	421.34	423.48	420.5	422.79	6247955.0
2022-03-14 10:30:00	SPY	ETF	422.79	424.33	422.06	424.315	4572107.0
2022-03-14 11:00:00	SPY	ETF	424.33	424.55	422.09	422.27	3780115.0
2022-03-14 11:30:00	SPY	ETF	422.28	422.46	419.91	420.46	4318221.0
2022-03-14 12:00:00	SPY	ETF	420.45	420.46	418.84	419.81	4907703.0
2022-03-14 12:30:00	SPY	ETF	419.805	420.17	417.83	417.9	4224839.0
2022-03-14 13:00:00	SPY	ETF	417.9	418.14	417.3	417.42	3962962.0
2022-03-14 13:30:00	SPY	ETF	417.4201	417.65	416.12	416.71	5156173.0
2022-03-14 14:00:00	SPY	ETF	416.71	417.26	415.79	415.9	3584035.0
2022-03-14 14:30:00	SPY	ETF	415.91	417.29	415.81	417.12	4029407.0
2022-03-14 15:00:00	SPY	ETF	417.13	418.2	416.65	417.17	5176725.0
2022-03-14 15:30:00	SPY	ETF	417.19	417.71	416.01	417.06	12250249.0
2022-03-14 16:00:00	SPY	ETF	417.06	418.11	416.85	417.6	3990595.0
2022-03-14 16:30:00	SPY	ETF	417.58	417.75	417.48	417.74	206434.0
2022-03-14 17:00:00	SPY	ETF	417.83	417.88	417.31	417.31	80982.0
2022-03-14 17:30:00	SPY	ETF	417.36	417.65	417.0	417.65	67587.0
2022-03-14 18:00:00	SPY	ETF	417.65	417.89	417.38	417.38	97630.0
2022-03-14 18:30:00	SPY	ETF	417.39	418.48	417.39	418.2	81748.0
2022-03-14 19:00:00	SPY	ETF	418.2	418.2	417.7	418.15	50793.0
2022-03-14 19:30:00	SPY	ETF	418.2	418.29	417.87	417.89	57888.0
2022-03-14 04:00:00	QQQ	ETF	325.04	328.0	324.77	324.77	68433.0
2022-03-14 04:30:00	QQQ	ETF	324.66	325.57	324.39	325.29	45899.0
2022-03-14 05:00:00	QQQ	ETF	325.3	326.25	324.97	325.22	42092.0
2022-03-14 05:30:00	QQQ	ETF	325.08	327.73	325.08	327.04	74055.0
2022-03-14 06:00:00	QQQ	ETF	327.04	327.1	326.24	326.42	105306.0
2022-03-14 06:30:00	QQQ	ETF	326.58	326.85	325.83	326.39	26653.0
2022-03-14 07:00:00	QQQ	ETF	326.42	326.5	323.5	323.79	218153.0
2022-03-14 07:30:00	QQQ	ETF	323.8	324.42	322.54	322.81	287336.0
2022-03-14 08:00:00	QQQ	ETF	324.1999	327.8496	322.56	323.37	282985.0
2022-03-14 08:30:00	QQQ	ETF	323.45	324.85	323.33	324.61	316553.0
2022-03-14 09:00:00	QQQ	ETF	324.68	324.68	323.11	323.12	434907.0
2022-03-14 09:30:00	QQQ	ETF	323.13	325.32	322.02	323.7393	7211450.0
2022-03-14 10:00:00	QQQ	ETF	323.71	326.59	322.8	325.3	4585544.0
2022-03-14 10:30:00	QQQ	ETF	325.32	326.34	324.115	326.0	4438188.0
2022-03-14 11:00:00	QQQ	ETF	326.02	326.19	323.13	323.32	3617127.0
2022-03-14 11:30:00	QQQ	ETF	323.34	323.49	321.26	321.65	3758156.0
2022-03-14 12:00:00	QQQ	ETF	321.6	321.65	320.19	320.99	4119908.0
2022-03-14 12:30:00	QQQ	ETF	321.0	321.27	318.91	318.96	4014816.0

> showing 50 of 27,407 rows — these rows as CSV

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