PREVIEW / etf_30min / 2009-06-18

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-18.parquet
  size:    218 KB
  rows:    7,155

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-06-18 04:00:00	SPY	ETF	91.71	91.71	91.55	91.55	2500.0
2009-06-18 04:30:00	SPY	ETF	91.52	91.56	91.5	91.56	1800.0
2009-06-18 05:30:00	SPY	ETF	91.65	91.68	91.57	91.62	26200.0
2009-06-18 06:00:00	SPY	ETF	91.67	91.67	91.67	91.67	100.0
2009-06-18 06:30:00	SPY	ETF	91.58	91.58	91.28	91.33	22500.0
2009-06-18 07:00:00	SPY	ETF	91.31	91.62	91.31	91.62	390834.0
2009-06-18 07:30:00	SPY	ETF	91.63	91.69	91.25	91.29	242228.0
2009-06-18 08:00:00	SPY	ETF	91.29	91.477	91.23	91.34	1312576.0
2009-06-18 08:30:00	SPY	ETF	91.33	91.86	91.29	91.74	3513739.0
2009-06-18 09:00:00	SPY	ETF	91.75	91.82	91.54	91.68	750445.0
2009-06-18 09:30:00	SPY	ETF	91.69	92.28	91.25	92.21	29317823.0
2009-06-18 10:00:00	SPY	ETF	92.21	92.53	92.16	92.32	25508214.0
2009-06-18 10:30:00	SPY	ETF	92.33	92.41	91.99	92.08	13645359.0
2009-06-18 11:00:00	SPY	ETF	92.08	92.39	92.06	92.27	10239065.0
2009-06-18 11:30:00	SPY	ETF	92.26	92.34	92.05	92.3	7411169.0
2009-06-18 12:00:00	SPY	ETF	92.3099	92.36	92.16	92.3097	6525125.0
2009-06-18 12:30:00	SPY	ETF	92.3	92.49	92.26	92.48	6731798.0
2009-06-18 13:00:00	SPY	ETF	92.48	92.67	92.42	92.61	10365639.0
2009-06-18 13:30:00	SPY	ETF	92.61	92.63	92.37	92.39	8634237.0
2009-06-18 14:00:00	SPY	ETF	92.39	92.42	92.15	92.31	18227940.0
2009-06-18 14:30:00	SPY	ETF	92.3	92.53	92.2	92.47	14559163.0
2009-06-18 15:00:00	SPY	ETF	92.47	92.63	92.37	92.401	10626809.0
2009-06-18 15:30:00	SPY	ETF	92.41	92.52	92.02	92.18	25350604.0
2009-06-18 16:00:00	SPY	ETF	92.16	92.58	92.02	92.18	12084697.0
2009-06-18 16:30:00	SPY	ETF	92.18	92.35	92.13	92.25	4179786.0
2009-06-18 17:00:00	SPY	ETF	92.25	92.36	92.22	92.36	107363.0
2009-06-18 17:30:00	SPY	ETF	92.36	92.45	92.36	92.45	68484.0
2009-06-18 18:00:00	SPY	ETF	92.44	92.49	92.4	92.42	271271.0
2009-06-18 18:30:00	SPY	ETF	92.44	92.46	92.43	92.45	32300.0
2009-06-18 19:00:00	SPY	ETF	92.44	92.48	92.44	92.47	9290.0
2009-06-18 19:30:00	SPY	ETF	92.47	92.51	92.47	92.49	21629.0
2009-06-18 05:00:00	QQQ	ETF	35.77	35.77	35.77	35.77	100.0
2009-06-18 06:30:00	QQQ	ETF	35.73	35.73	35.65	35.65	5600.0
2009-06-18 07:00:00	QQQ	ETF	35.67	35.78	35.67	35.75	75658.0
2009-06-18 07:30:00	QQQ	ETF	35.82	35.83	35.65	35.68	94500.0
2009-06-18 08:00:00	QQQ	ETF	35.68	35.73	35.68	35.72	537787.0
2009-06-18 08:30:00	QQQ	ETF	35.73	35.91	35.7	35.88	376358.0
2009-06-18 09:00:00	QQQ	ETF	35.88	35.89	35.83	35.83	510013.0
2009-06-18 09:30:00	QQQ	ETF	35.83	35.95	35.57	35.89	23023580.0
2009-06-18 10:00:00	QQQ	ETF	35.89	36.06	35.86	35.87	13678242.0
2009-06-18 10:30:00	QQQ	ETF	35.87	35.91	35.73	35.79	8591751.0
2009-06-18 11:00:00	QQQ	ETF	35.79	35.86	35.77	35.8	4926862.0
2009-06-18 11:30:00	QQQ	ETF	35.8	35.82	35.71	35.82	2687879.0
2009-06-18 12:00:00	QQQ	ETF	35.82	35.87	35.79	35.83	2976401.0
2009-06-18 12:30:00	QQQ	ETF	35.83	36.0	35.81	35.98	4403221.0
2009-06-18 13:00:00	QQQ	ETF	35.99	36.05	35.93	36.01	5155953.0
2009-06-18 13:30:00	QQQ	ETF	36.01	36.02	35.9	35.94	5043250.0
2009-06-18 14:00:00	QQQ	ETF	35.95	35.96	35.86	35.92	5629716.0
2009-06-18 14:30:00	QQQ	ETF	35.92	35.96	35.87	35.95	4637801.0
2009-06-18 15:00:00	QQQ	ETF	35.95	36.0	35.85	35.8621	4907599.0

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

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