PREVIEW / etf_30min / 2022-03-08

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-03-08.parquet
  size:    709 KB
  rows:    28,803

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-08 04:00:00	SPY	ETF	420.0	421.62	420.0	420.8	49307.0
2022-03-08 04:30:00	SPY	ETF	420.73	421.35	420.25	421.0	63178.0
2022-03-08 05:00:00	SPY	ETF	421.08	421.08	419.14	420.72	45464.0
2022-03-08 05:30:00	SPY	ETF	420.59	421.51	419.83	421.22	81350.0
2022-03-08 06:00:00	SPY	ETF	421.0	421.38	420.33	421.26	63235.0
2022-03-08 06:30:00	SPY	ETF	421.2	421.64	420.69	421.64	80079.0
2022-03-08 07:00:00	SPY	ETF	421.59	423.03	421.48	421.8	539852.0
2022-03-08 07:30:00	SPY	ETF	421.78	422.06	419.72	420.2	349593.0
2022-03-08 08:00:00	SPY	ETF	421.5499	423.0	414.0	419.1	670743.0
2022-03-08 08:30:00	SPY	ETF	419.1	420.6	418.7	419.88	607647.0
2022-03-08 09:00:00	SPY	ETF	419.8	420.59	419.12	419.7	460888.0
2022-03-08 09:30:00	SPY	ETF	419.7	421.19	417.76	418.6899	11813699.0
2022-03-08 10:00:00	SPY	ETF	418.678	419.235	415.76	416.37	9396290.0
2022-03-08 10:30:00	SPY	ETF	416.36	419.56	415.39	419.32	7902389.0
2022-03-08 11:00:00	SPY	ETF	419.35	419.77	416.36	416.7	6223265.0
2022-03-08 11:30:00	SPY	ETF	416.68	418.68	415.12	417.9401	5557009.0
2022-03-08 12:00:00	SPY	ETF	417.97	424.59	417.68	423.83	11664712.0
2022-03-08 12:30:00	SPY	ETF	423.79	425.56	423.0	425.165	7472081.0
2022-03-08 13:00:00	SPY	ETF	425.18	427.21	423.48	423.76	7792773.0
2022-03-08 13:30:00	SPY	ETF	423.78	423.8	419.36	419.53	8913158.0
2022-03-08 14:00:00	SPY	ETF	419.52	421.01	417.81	420.83	10165416.0
2022-03-08 14:30:00	SPY	ETF	420.83	422.77	419.6438	421.47	6181643.0
2022-03-08 15:00:00	SPY	ETF	421.47	423.53	418.94	419.07	6446524.0
2022-03-08 15:30:00	SPY	ETF	419.07	419.349	416.25	416.3	17765540.0
2022-03-08 16:00:00	SPY	ETF	416.3	416.5532	414.82	415.04	6848486.0
2022-03-08 16:30:00	SPY	ETF	415.06	415.35	414.58	414.94	299863.0
2022-03-08 17:00:00	SPY	ETF	415.12	416.25	414.7	414.75	145489.0
2022-03-08 17:30:00	SPY	ETF	414.76	414.8	414.61	414.75	106897.0
2022-03-08 18:00:00	SPY	ETF	414.81	415.88	414.81	415.81	168500.0
2022-03-08 18:30:00	SPY	ETF	415.95	416.75	415.95	416.59	132290.0
2022-03-08 19:00:00	SPY	ETF	416.67	417.46	416.62	417.2301	146292.0
2022-03-08 19:30:00	SPY	ETF	417.2404	417.75	416.63	417.45	107149.0
2022-03-08 04:00:00	QQQ	ETF	324.76	326.18	324.61	325.4	111542.0
2022-03-08 04:30:00	QQQ	ETF	325.44	325.9	325.0	325.36	57938.0
2022-03-08 05:00:00	QQQ	ETF	325.69	325.71	323.99	325.23	67111.0
2022-03-08 05:30:00	QQQ	ETF	325.0	325.72	324.39	325.65	48123.0
2022-03-08 06:00:00	QQQ	ETF	325.3	325.49	324.41	325.29	51981.0
2022-03-08 06:30:00	QQQ	ETF	325.16	325.75	324.74	325.56	134069.0
2022-03-08 07:00:00	QQQ	ETF	325.55	327.3	325.41	326.02	346886.0
2022-03-08 07:30:00	QQQ	ETF	326.02	326.3	324.2	324.58	584116.0
2022-03-08 08:00:00	QQQ	ETF	324.56	327.2701	319.9	323.5	652403.0
2022-03-08 08:30:00	QQQ	ETF	323.5	324.73	323.13	324.08	356951.0
2022-03-08 09:00:00	QQQ	ETF	324.06	324.9	323.66	324.02	429160.0
2022-03-08 09:30:00	QQQ	ETF	324.05	326.13	322.46	323.18	11284201.0
2022-03-08 10:00:00	QQQ	ETF	323.155	324.0	320.37	321.46	8551226.0
2022-03-08 10:30:00	QQQ	ETF	321.43	324.93	320.05	324.63	6683479.0
2022-03-08 11:00:00	QQQ	ETF	324.63	325.39	321.3	321.82	5284178.0
2022-03-08 11:30:00	QQQ	ETF	321.81	323.37	319.94	322.4701	4504922.0
2022-03-08 12:00:00	QQQ	ETF	322.5	330.47	322.21	329.55	8492240.0
2022-03-08 12:30:00	QQQ	ETF	329.52	332.07	328.49	331.4	5897862.0

> showing 50 of 28,803 rows — these rows as CSV

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