PREVIEW / etf_30min / 2009-11-03

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-11-03.parquet
  size:    235 KB
  rows:    7,757

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-03 04:00:00	SPY	ETF	103.97	103.99	103.85	103.85	2881.0
2009-11-03 04:30:00	SPY	ETF	103.83	103.83	103.38	103.38	2438.0
2009-11-03 05:00:00	SPY	ETF	103.33	103.49	103.28	103.4	10709.0
2009-11-03 05:30:00	SPY	ETF	103.39	103.53	103.35	103.53	2530.0
2009-11-03 06:00:00	SPY	ETF	103.54	103.59	103.16	103.24	21856.0
2009-11-03 06:30:00	SPY	ETF	103.29	103.34	103.21	103.24	32550.0
2009-11-03 07:00:00	SPY	ETF	103.28	103.53	103.24	103.43	435439.0
2009-11-03 07:30:00	SPY	ETF	103.46	103.98	103.46	103.72	1908637.0
2009-11-03 08:00:00	SPY	ETF	103.9	104.36	103.4	103.93	4184903.0
2009-11-03 08:30:00	SPY	ETF	103.94	103.95	102.49	103.65	2447439.0
2009-11-03 09:00:00	SPY	ETF	103.66	103.76	103.58	103.74	1534329.0
2009-11-03 09:30:00	SPY	ETF	103.74	104.38	103.54	104.25	29982421.0
2009-11-03 10:00:00	SPY	ETF	104.23	104.54	103.8	103.8901	25002002.0
2009-11-03 10:30:00	SPY	ETF	103.89	104.46	103.75	104.1698	19095604.0
2009-11-03 11:00:00	SPY	ETF	104.16	104.369	103.76	103.89	14670795.0
2009-11-03 11:30:00	SPY	ETF	103.89	104.07	103.6	103.9203	19495491.0
2009-11-03 12:00:00	SPY	ETF	103.9201	104.11	103.7	103.98	9911943.0
2009-11-03 12:30:00	SPY	ETF	103.98	104.62	103.96	104.225	13606317.0
2009-11-03 13:00:00	SPY	ETF	104.2201	104.44	104.13	104.22	7603668.0
2009-11-03 13:30:00	SPY	ETF	104.22	104.51	104.19	104.495	8287130.0
2009-11-03 14:00:00	SPY	ETF	104.5	104.8	104.35	104.58	10515150.0
2009-11-03 14:30:00	SPY	ETF	104.57	104.74	104.13	104.22	10910224.0
2009-11-03 15:00:00	SPY	ETF	104.22	104.42	104.16	104.4	10219601.0
2009-11-03 15:30:00	SPY	ETF	104.4	104.75	104.4	104.67	22957986.0
2009-11-03 16:00:00	SPY	ETF	104.67	104.75	103.7659	104.75	5795163.0
2009-11-03 16:30:00	SPY	ETF	104.71	104.71	104.4358	104.67	8487072.0
2009-11-03 17:00:00	SPY	ETF	104.65	104.68	104.6	104.68	30481.0
2009-11-03 17:30:00	SPY	ETF	104.69	104.7	104.4358	104.65	1012689.0
2009-11-03 18:00:00	SPY	ETF	104.65	104.7	104.58	104.69	32078.0
2009-11-03 18:30:00	SPY	ETF	104.72	104.8	104.72	104.79	14021.0
2009-11-03 19:00:00	SPY	ETF	104.75	104.75	103.79	104.74	11234.0
2009-11-03 19:30:00	SPY	ETF	104.74	104.82	104.67	104.78	14300.0
2009-11-03 04:00:00	QQQ	ETF	40.89	40.89	40.89	40.89	424.0
2009-11-03 04:30:00	QQQ	ETF	40.85	40.85	40.84	40.84	200.0
2009-11-03 05:00:00	QQQ	ETF	40.71	40.75	40.69	40.75	900.0
2009-11-03 05:30:00	QQQ	ETF	40.76	40.76	40.75	40.76	5655.0
2009-11-03 06:00:00	QQQ	ETF	40.79	40.79	40.69	40.72	43155.0
2009-11-03 06:30:00	QQQ	ETF	40.7	40.7	40.7	40.7	100.0
2009-11-03 07:00:00	QQQ	ETF	40.73	40.82	40.73	40.82	166069.0
2009-11-03 07:30:00	QQQ	ETF	40.84	41.02	40.84	40.94	922071.0
2009-11-03 08:00:00	QQQ	ETF	40.92	41.04	40.8	41.0	2355108.0
2009-11-03 08:30:00	QQQ	ETF	41.0	41.0	40.84	40.93	1057043.0
2009-11-03 09:00:00	QQQ	ETF	40.93	40.99	40.9	40.98	1256527.0
2009-11-03 09:30:00	QQQ	ETF	40.97	41.08	40.84	41.02	14714641.0
2009-11-03 10:00:00	QQQ	ETF	41.02	41.17	40.8799	40.9	10580783.0
2009-11-03 10:30:00	QQQ	ETF	40.9	41.09	40.85	41.0	7078670.0
2009-11-03 11:00:00	QQQ	ETF	41.0	41.0895	40.89	40.95	6137957.0
2009-11-03 11:30:00	QQQ	ETF	40.95	41.02	40.84	40.96	3716872.0
2009-11-03 12:00:00	QQQ	ETF	40.96	41.02	40.85	40.99	4820680.0
2009-11-03 12:30:00	QQQ	ETF	40.98	41.21	40.98	41.1018	4920078.0

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

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