PREVIEW / etf_30min / 2009-05-07

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-05-07.parquet
  size:    231 KB
  rows:    7,574

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-05-07 04:00:00	SPY	ETF	92.33	92.36	92.3	92.36	1400.0
2009-05-07 04:30:00	SPY	ETF	92.29	92.49	92.29	92.49	6700.0
2009-05-07 05:00:00	SPY	ETF	92.53	92.54	92.43	92.54	3000.0
2009-05-07 05:30:00	SPY	ETF	92.59	92.7	92.59	92.7	3300.0
2009-05-07 06:00:00	SPY	ETF	92.7	92.74	92.61	92.74	17000.0
2009-05-07 06:30:00	SPY	ETF	92.73	92.81	92.69	92.69	61461.0
2009-05-07 07:00:00	SPY	ETF	92.71	92.73	92.58	92.69	262290.0
2009-05-07 07:30:00	SPY	ETF	92.69	92.85	92.64	92.83	910376.0
2009-05-07 08:00:00	SPY	ETF	92.83	93.15	92.05	93.06	2505334.0
2009-05-07 08:30:00	SPY	ETF	93.07	93.47	92.12	92.88	4240108.0
2009-05-07 09:00:00	SPY	ETF	92.88	93.08	92.83	93.02	2332561.0
2009-05-07 09:30:00	SPY	ETF	93.01	93.15	92.32	92.43	35378386.0
2009-05-07 10:00:00	SPY	ETF	92.44	93.1	91.45	91.57	36867549.0
2009-05-07 10:30:00	SPY	ETF	91.58	91.93	91.33	91.74	21767908.0
2009-05-07 11:00:00	SPY	ETF	91.74	92.15	91.12	91.365	19201330.0
2009-05-07 11:30:00	SPY	ETF	91.34	91.71	91.26	91.62	12130832.0
2009-05-07 12:00:00	SPY	ETF	91.62	91.62	91.31	91.4394	8286541.0
2009-05-07 12:30:00	SPY	ETF	91.44	91.74	91.37	91.581	7514059.0
2009-05-07 13:00:00	SPY	ETF	91.59	91.64	90.98	90.995	20752698.0
2009-05-07 13:30:00	SPY	ETF	91.0	91.06	90.59	90.88	17704010.0
2009-05-07 14:00:00	SPY	ETF	90.88	91.03	90.59	90.91	12770409.0
2009-05-07 14:30:00	SPY	ETF	90.9	90.91	90.35	90.58	19478231.0
2009-05-07 15:00:00	SPY	ETF	90.57	90.925	90.36	90.78	25096509.0
2009-05-07 15:30:00	SPY	ETF	90.78	91.11	90.28	90.84	44106928.0
2009-05-07 16:00:00	SPY	ETF	90.85	92.1224	90.7285	91.13	14909238.0
2009-05-07 16:30:00	SPY	ETF	91.15	91.2	90.75	90.97	5716466.0
2009-05-07 17:00:00	SPY	ETF	90.96	91.55	90.94	91.54	2861296.0
2009-05-07 17:30:00	SPY	ETF	91.54	91.8	91.46	91.64	284621.0
2009-05-07 18:00:00	SPY	ETF	91.6	91.77	90.68	91.63	183444.0
2009-05-07 18:30:00	SPY	ETF	91.65	91.67	91.56	91.6	14910.0
2009-05-07 19:00:00	SPY	ETF	91.63	91.68	91.59	91.59	10105.0
2009-05-07 19:30:00	SPY	ETF	90.7999	91.65	90.6801	91.6	38099.0
2009-05-07 05:00:00	QQQ	ETF	35.18	35.19	35.14	35.19	17684.0
2009-05-07 06:00:00	QQQ	ETF	35.23	35.23	35.23	35.23	1300.0
2009-05-07 06:30:00	QQQ	ETF	35.25	35.28	35.25	35.26	15202.0
2009-05-07 07:00:00	QQQ	ETF	35.26	35.27	35.19	35.21	68632.0
2009-05-07 07:30:00	QQQ	ETF	35.17	35.27	35.17	35.24	152098.0
2009-05-07 08:00:00	QQQ	ETF	35.23	35.3	35.0	35.27	655872.0
2009-05-07 08:30:00	QQQ	ETF	35.27	35.39	35.21	35.22	2501290.0
2009-05-07 09:00:00	QQQ	ETF	35.22	35.28	35.19	35.24	1692874.0
2009-05-07 09:30:00	QQQ	ETF	35.25	35.27	34.58	34.5999	21399510.0
2009-05-07 10:00:00	QQQ	ETF	34.59	34.65	34.22	34.24	27041827.0
2009-05-07 10:30:00	QQQ	ETF	34.2496	34.41	34.2	34.35	11949438.0
2009-05-07 11:00:00	QQQ	ETF	34.36	34.43	34.13	34.19	17372390.0
2009-05-07 11:30:00	QQQ	ETF	34.18	34.37	34.17	34.36	10914344.0
2009-05-07 12:00:00	QQQ	ETF	34.36	34.38	34.22	34.25	6124850.0
2009-05-07 12:30:00	QQQ	ETF	34.2599	34.37	34.24	34.349	4092743.0
2009-05-07 13:00:00	QQQ	ETF	34.35	34.36	34.17	34.2	10830263.0
2009-05-07 13:30:00	QQQ	ETF	34.2	34.22	34.0	34.061	13453760.0
2009-05-07 14:00:00	QQQ	ETF	34.06	34.12	33.98	34.08	9413730.0

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

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