PREVIEW / etf_30min / 2009-10-15

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-15.parquet
  size:    236 KB
  rows:    7,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
2009-10-15 04:00:00	SPY	ETF	109.2	109.2	109.2	109.2	100.0
2009-10-15 05:00:00	SPY	ETF	109.28	109.28	109.28	109.28	2000.0
2009-10-15 06:00:00	SPY	ETF	109.3	109.3	109.19	109.19	5300.0
2009-10-15 06:30:00	SPY	ETF	109.28	109.28	109.22	109.22	7900.0
2009-10-15 07:00:00	SPY	ETF	109.3	109.45	108.87	108.91	1137901.0
2009-10-15 07:30:00	SPY	ETF	108.91	108.97	108.69	108.72	634925.0
2009-10-15 08:00:00	SPY	ETF	108.8	108.92	108.49	108.62	2188002.0
2009-10-15 08:30:00	SPY	ETF	108.62	108.83	108.53	108.68	2630181.0
2009-10-15 09:00:00	SPY	ETF	108.68	108.83	108.68	108.78	1338975.0
2009-10-15 09:30:00	SPY	ETF	108.78	109.22	108.74	109.219	18992056.0
2009-10-15 10:00:00	SPY	ETF	109.21	109.22	108.84	108.9392	16001747.0
2009-10-15 10:30:00	SPY	ETF	108.94	109.02	108.73	108.97	12915122.0
2009-10-15 11:00:00	SPY	ETF	108.97	109.13	108.83	108.8801	10223987.0
2009-10-15 11:30:00	SPY	ETF	108.88	109.06	108.81	109.02	5109319.0
2009-10-15 12:00:00	SPY	ETF	109.03	109.26	109.02	109.11	11460552.0
2009-10-15 12:30:00	SPY	ETF	109.1101	109.17	109.02	109.04	4904586.0
2009-10-15 13:00:00	SPY	ETF	109.04	109.18	108.98	109.1701	4003045.0
2009-10-15 13:30:00	SPY	ETF	109.18	109.24	109.1	109.168	5872814.0
2009-10-15 14:00:00	SPY	ETF	109.17	109.3	109.12	109.2	10882208.0
2009-10-15 14:30:00	SPY	ETF	109.2	109.57	109.19	109.53	12472127.0
2009-10-15 15:00:00	SPY	ETF	109.52	109.62	109.3	109.31	11021405.0
2009-10-15 15:30:00	SPY	ETF	109.3	109.7	109.28	109.63	21456835.0
2009-10-15 16:00:00	SPY	ETF	109.62	109.78	108.83	109.5	13934342.0
2009-10-15 16:30:00	SPY	ETF	109.5	109.63	109.41	109.44	4469371.0
2009-10-15 17:00:00	SPY	ETF	109.43	109.63	109.43	109.51	78807.0
2009-10-15 17:30:00	SPY	ETF	109.5	109.54	109.46	109.51	45399.0
2009-10-15 18:00:00	SPY	ETF	109.5	109.6	109.5	109.56	12889.0
2009-10-15 18:30:00	SPY	ETF	109.55	109.55	109.51	109.51	3810.0
2009-10-15 19:00:00	SPY	ETF	109.51	109.58	109.51	109.55	9036.0
2009-10-15 19:30:00	SPY	ETF	109.56	109.6	109.56	109.59	54080.0
2009-10-15 04:30:00	QQQ	ETF	43.08	43.08	43.08	43.08	100.0
2009-10-15 06:00:00	QQQ	ETF	43.04	43.07	43.03	43.05	8300.0
2009-10-15 06:30:00	QQQ	ETF	43.06	43.06	43.03	43.03	17090.0
2009-10-15 07:00:00	QQQ	ETF	43.04	43.07	42.89	42.9	131505.0
2009-10-15 07:30:00	QQQ	ETF	42.92	42.92	42.84	42.86	113104.0
2009-10-15 08:00:00	QQQ	ETF	42.86	42.9	42.77	42.82	553894.0
2009-10-15 08:30:00	QQQ	ETF	42.83	42.93	42.79	42.85	870718.0
2009-10-15 09:00:00	QQQ	ETF	42.86	42.93	42.85	42.92	392317.0
2009-10-15 09:30:00	QQQ	ETF	42.93	43.12	42.91	43.11	11617222.0
2009-10-15 10:00:00	QQQ	ETF	43.1101	43.12	42.96	42.978	9460009.0
2009-10-15 10:30:00	QQQ	ETF	42.97	43.01	42.87	42.94	6257822.0
2009-10-15 11:00:00	QQQ	ETF	42.94	42.99	42.88	42.91	5773419.0
2009-10-15 11:30:00	QQQ	ETF	42.91	42.99	42.9	42.979	4054244.0
2009-10-15 12:00:00	QQQ	ETF	42.97	43.05	42.97	42.98	4556761.0
2009-10-15 12:30:00	QQQ	ETF	42.98	43.0	42.93	42.9404	2481911.0
2009-10-15 13:00:00	QQQ	ETF	42.95	43.0	42.94	42.99	1762466.0
2009-10-15 13:30:00	QQQ	ETF	42.998	43.01	42.95	42.98	3028252.0
2009-10-15 14:00:00	QQQ	ETF	42.97	43.01	42.9079	42.94	4167286.0
2009-10-15 14:30:00	QQQ	ETF	42.94	43.12	42.93	43.085	5573350.0
2009-10-15 15:00:00	QQQ	ETF	43.09	43.12	43.0	43.01	5043859.0

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

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