PREVIEW / etf_30min / 2009-11-16

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-11-16.parquet
  size:    239 KB
  rows:    8,047

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-11-16 04:00:00	SPY	ETF	110.4	110.57	110.4	110.57	5500.0
2009-11-16 04:30:00	SPY	ETF	110.46	110.46	110.46	110.46	100.0
2009-11-16 05:00:00	SPY	ETF	110.5	110.51	110.5	110.51	26099.0
2009-11-16 05:30:00	SPY	ETF	110.53	110.53	110.53	110.53	100.0
2009-11-16 06:00:00	SPY	ETF	110.51	110.51	110.39	110.43	25799.0
2009-11-16 06:30:00	SPY	ETF	110.5	110.54	110.48	110.51	10406.0
2009-11-16 07:00:00	SPY	ETF	110.46	110.49	110.39	110.45	162541.0
2009-11-16 07:30:00	SPY	ETF	110.43	110.55	110.42	110.48	551661.0
2009-11-16 08:00:00	SPY	ETF	110.5	110.63	110.25	110.52	2451252.0
2009-11-16 08:30:00	SPY	ETF	110.52	110.7	110.32	110.38	1811175.0
2009-11-16 09:00:00	SPY	ETF	110.38	110.45	110.36	110.37	710175.0
2009-11-16 09:30:00	SPY	ETF	110.38	111.21	110.32	111.09	26194146.0
2009-11-16 10:00:00	SPY	ETF	111.09	111.4	111.08	111.25	18825673.0
2009-11-16 10:30:00	SPY	ETF	111.26	111.44	111.2	111.4	10941639.0
2009-11-16 11:00:00	SPY	ETF	111.4	111.42	111.2	111.24	7886620.0
2009-11-16 11:30:00	SPY	ETF	111.25	111.47	111.24	111.37	9564043.0
2009-11-16 12:00:00	SPY	ETF	111.37	111.41	110.95	111.16	14850327.0
2009-11-16 12:30:00	SPY	ETF	111.17	111.42	111.0	111.41	7002752.0
2009-11-16 13:00:00	SPY	ETF	111.41	111.57	111.28	111.33	6823543.0
2009-11-16 13:30:00	SPY	ETF	111.34	111.53	111.305	111.46	5380720.0
2009-11-16 14:00:00	SPY	ETF	111.46	111.67	111.4	111.56	9254521.0
2009-11-16 14:30:00	SPY	ETF	111.56	111.69	111.36	111.46	9805377.0
2009-11-16 15:00:00	SPY	ETF	111.4501	111.49	110.84	110.89	21119286.0
2009-11-16 15:30:00	SPY	ETF	110.89	111.27	110.84	111.21	32584142.0
2009-11-16 16:00:00	SPY	ETF	111.2	111.61	109.6454	111.13	18171310.0
2009-11-16 16:30:00	SPY	ETF	111.13	111.15	109.6454	111.09	2279269.0
2009-11-16 17:00:00	SPY	ETF	111.1	111.11	111.06	111.06	2216093.0
2009-11-16 17:30:00	SPY	ETF	111.1	111.1	111.03	111.04	389479.0
2009-11-16 18:00:00	SPY	ETF	111.05	111.08	110.98	110.98	38043.0
2009-11-16 18:30:00	SPY	ETF	110.98	111.12	110.98	111.11	12950.0
2009-11-16 19:00:00	SPY	ETF	111.12	111.12	111.05	111.05	9182.0
2009-11-16 19:30:00	SPY	ETF	111.02	111.08	111.01	111.04	16957.0
2009-11-16 06:00:00	QQQ	ETF	44.22	44.22	44.22	44.22	100.0
2009-11-16 06:30:00	QQQ	ETF	44.3	44.3	44.3	44.3	100.0
2009-11-16 07:00:00	QQQ	ETF	44.24	44.26	44.23	44.23	45600.0
2009-11-16 07:30:00	QQQ	ETF	44.27	44.28	44.25	44.27	399941.0
2009-11-16 08:00:00	QQQ	ETF	44.33	44.35	44.26	44.27	378608.0
2009-11-16 08:30:00	QQQ	ETF	44.27	44.32	44.19	44.23	1189025.0
2009-11-16 09:00:00	QQQ	ETF	44.23	44.25	44.19	44.2	678669.0
2009-11-16 09:30:00	QQQ	ETF	44.19	44.55	44.12	44.49	14612257.0
2009-11-16 10:00:00	QQQ	ETF	44.49	44.59	44.46	44.53	6948263.0
2009-11-16 10:30:00	QQQ	ETF	44.53	44.57	44.49	44.5501	3383910.0
2009-11-16 11:00:00	QQQ	ETF	44.56	44.56	44.47	44.47	2936622.0
2009-11-16 11:30:00	QQQ	ETF	44.47	44.62	44.47	44.6	6484958.0
2009-11-16 12:00:00	QQQ	ETF	44.5999	44.61	44.44	44.52	5592912.0
2009-11-16 12:30:00	QQQ	ETF	44.51	44.58	44.47	44.5723	3457067.0
2009-11-16 13:00:00	QQQ	ETF	44.5701	44.6197	44.52	44.548	3174574.0
2009-11-16 13:30:00	QQQ	ETF	44.54	44.6	44.53	44.59	1917112.0
2009-11-16 14:00:00	QQQ	ETF	44.59	44.63	44.58	44.6	3955443.0
2009-11-16 14:30:00	QQQ	ETF	44.6099	44.65	44.53	44.57	3307055.0

> showing 50 of 8,047 rows — these rows as CSV

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