PREVIEW / etf_30min / 2009-10-01

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-01.parquet
  size:    243 KB
  rows:    7,951

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
2009-10-01 04:30:00	SPY	ETF	105.59	105.59	105.23	105.41	26250.0
2009-10-01 05:00:00	SPY	ETF	105.37	105.51	105.37	105.38	5300.0
2009-10-01 05:30:00	SPY	ETF	105.43	105.43	105.21	105.21	4000.0
2009-10-01 06:00:00	SPY	ETF	105.27	105.31	105.2	105.3	16500.0
2009-10-01 06:30:00	SPY	ETF	105.25	105.25	105.07	105.16	16056.0
2009-10-01 07:00:00	SPY	ETF	105.16	105.28	105.1	105.21	208097.0
2009-10-01 07:30:00	SPY	ETF	105.21	105.3	105.12	105.18	105159.0
2009-10-01 08:00:00	SPY	ETF	105.2	105.35	105.12	105.3	1357289.0
2009-10-01 08:30:00	SPY	ETF	105.28	105.49	104.98	105.42	3939114.0
2009-10-01 09:00:00	SPY	ETF	105.43	105.56	104.85	105.33	5485162.0
2009-10-01 09:30:00	SPY	ETF	105.34	105.37	104.72	104.98	29981566.0
2009-10-01 10:00:00	SPY	ETF	104.92	105.28	103.81	104.3	42471366.0
2009-10-01 10:30:00	SPY	ETF	104.3	104.555	104.18	104.33	12153880.0
2009-10-01 11:00:00	SPY	ETF	104.34	104.35	103.64	103.73	22711360.0
2009-10-01 11:30:00	SPY	ETF	103.73	103.88	103.63	103.82	11617280.0
2009-10-01 12:00:00	SPY	ETF	103.83	104.03	103.65	103.97	8011972.0
2009-10-01 12:30:00	SPY	ETF	103.96	104.04	103.77	103.85	6435585.0
2009-10-01 13:00:00	SPY	ETF	103.85	103.87	103.36	103.53	16437593.0
2009-10-01 13:30:00	SPY	ETF	103.53	103.79	103.42	103.665	11969649.0
2009-10-01 14:00:00	SPY	ETF	103.66	103.95	103.5	103.91	8860700.0
2009-10-01 14:30:00	SPY	ETF	103.9017	103.92	103.59	103.67	11793889.0
2009-10-01 15:00:00	SPY	ETF	103.67	103.7	103.43	103.49	16715394.0
2009-10-01 15:30:00	SPY	ETF	103.48	103.76	102.95	102.99	34111012.0
2009-10-01 16:00:00	SPY	ETF	102.99	105.7331	102.95	103.17	13527280.0
2009-10-01 16:30:00	SPY	ETF	103.17	105.7331	103.11	103.2	6665520.0
2009-10-01 17:00:00	SPY	ETF	103.72	105.7331	103.1	103.15	9665479.0
2009-10-01 17:30:00	SPY	ETF	103.11	103.21	103.1	103.11	140844.0
2009-10-01 18:00:00	SPY	ETF	103.12	105.7329	103.04	103.05	1121800.0
2009-10-01 18:30:00	SPY	ETF	103.05	103.14	103.02	103.08	23175.0
2009-10-01 19:00:00	SPY	ETF	103.11	103.11	103.06	103.08	15290.0
2009-10-01 19:30:00	SPY	ETF	103.06	105.56	103.0	103.0	41969.0
2009-10-01 05:30:00	QQQ	ETF	42.05	42.05	42.05	42.05	4000.0
2009-10-01 06:00:00	QQQ	ETF	42.06	42.06	42.06	42.06	2000.0
2009-10-01 06:30:00	QQQ	ETF	42.06	42.07	42.04	42.05	15489.0
2009-10-01 07:00:00	QQQ	ETF	42.05	42.07	42.04	42.07	14379.0
2009-10-01 07:30:00	QQQ	ETF	42.08	42.1	42.02	42.03	109850.0
2009-10-01 08:00:00	QQQ	ETF	42.07	42.13	42.05	42.1	199315.0
2009-10-01 08:30:00	QQQ	ETF	42.08	42.17	41.97	42.14	871877.0
2009-10-01 09:00:00	QQQ	ETF	42.14	42.16	42.05	42.11	809383.0
2009-10-01 09:30:00	QQQ	ETF	42.11	42.13	41.87	41.96	13908348.0
2009-10-01 10:00:00	QQQ	ETF	41.96	42.05	41.5	41.62	26072478.0
2009-10-01 10:30:00	QQQ	ETF	41.61	41.69	41.52	41.58	7532409.0
2009-10-01 11:00:00	QQQ	ETF	41.57	41.58	41.2	41.22	12563809.0
2009-10-01 11:30:00	QQQ	ETF	41.2299	41.3	41.17	41.28	6731569.0
2009-10-01 12:00:00	QQQ	ETF	41.27	41.39	41.21	41.35	3919768.0
2009-10-01 12:30:00	QQQ	ETF	41.35	41.38	41.28	41.29	3351558.0
2009-10-01 13:00:00	QQQ	ETF	41.29	41.305	41.11	41.17	6553276.0
2009-10-01 13:30:00	QQQ	ETF	41.16	41.28	41.13	41.248	5224462.0
2009-10-01 14:00:00	QQQ	ETF	41.25	41.39	41.2	41.37	3928213.0
2009-10-01 14:30:00	QQQ	ETF	41.3678	41.38	41.23	41.27	4651516.0

> showing 50 of 7,951 rows — these rows as CSV

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