PREVIEW / etf_30min / 2009-07-13

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-13.parquet
  size:    217 KB
  rows:    7,074

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-07-13 04:30:00	SPY	ETF	87.75	87.96	87.57	87.57	2100.0
2009-07-13 05:00:00	SPY	ETF	87.59	87.59	87.44	87.52	16400.0
2009-07-13 05:30:00	SPY	ETF	87.5	87.5	87.39	87.42	1700.0
2009-07-13 06:00:00	SPY	ETF	87.34	87.63	87.31	87.63	25300.0
2009-07-13 06:30:00	SPY	ETF	87.55	87.9	87.55	87.87	32000.0
2009-07-13 07:00:00	SPY	ETF	87.93	87.98	87.59	87.74	135303.0
2009-07-13 07:30:00	SPY	ETF	87.75	88.02	87.64	88.01	210249.0
2009-07-13 08:00:00	SPY	ETF	87.99	88.4	87.24	88.34	1428298.0
2009-07-13 08:30:00	SPY	ETF	88.35	88.63	88.34	88.48	1832286.0
2009-07-13 09:00:00	SPY	ETF	88.47	88.58	88.25	88.3	1546616.0
2009-07-13 09:30:00	SPY	ETF	88.31	88.6	87.96	88.01	17561728.0
2009-07-13 10:00:00	SPY	ETF	88.0	88.19	87.59	88.18	21570740.0
2009-07-13 10:30:00	SPY	ETF	88.19	88.8	88.19	88.79	18124655.0
2009-07-13 11:00:00	SPY	ETF	88.79	88.87	88.65	88.85	11120913.0
2009-07-13 11:30:00	SPY	ETF	88.85	89.59	88.84	89.43	20454904.0
2009-07-13 12:00:00	SPY	ETF	89.432	89.55	89.31	89.42	6671896.0
2009-07-13 12:30:00	SPY	ETF	89.41	89.53	89.28	89.38	5669384.0
2009-07-13 13:00:00	SPY	ETF	89.38	89.75	89.35	89.68	10758946.0
2009-07-13 13:30:00	SPY	ETF	89.6801	89.72	89.53	89.6	9895371.0
2009-07-13 14:00:00	SPY	ETF	89.6	89.87	89.53	89.74	12480420.0
2009-07-13 14:30:00	SPY	ETF	89.73	89.82	89.6	89.68	10792492.0
2009-07-13 15:00:00	SPY	ETF	89.67	89.88	89.64	89.692	13131228.0
2009-07-13 15:30:00	SPY	ETF	89.692	90.17	89.64	90.12	37225256.0
2009-07-13 16:00:00	SPY	ETF	90.11	90.21	89.98	90.01	14417053.0
2009-07-13 16:30:00	SPY	ETF	90.04	90.05	89.87	89.99	430596.0
2009-07-13 17:00:00	SPY	ETF	89.97	90.08	89.95	90.01	926851.0
2009-07-13 17:30:00	SPY	ETF	90.06	90.21	90.02	90.2	299802.0
2009-07-13 18:00:00	SPY	ETF	90.12	90.15	90.05	90.08	175913.0
2009-07-13 18:30:00	SPY	ETF	90.08	90.08	89.99	90.0	53138.0
2009-07-13 19:00:00	SPY	ETF	90.01	90.02	89.95	89.98	36003.0
2009-07-13 19:30:00	SPY	ETF	89.97	90.0	89.93	90.0	92259.0
2009-07-13 05:00:00	QQQ	ETF	34.72	34.72	34.72	34.72	20000.0
2009-07-13 06:00:00	QQQ	ETF	34.67	34.76	34.67	34.76	31100.0
2009-07-13 06:30:00	QQQ	ETF	34.79	34.86	34.79	34.84	61500.0
2009-07-13 07:00:00	QQQ	ETF	34.89	34.9	34.76	34.86	71526.0
2009-07-13 07:30:00	QQQ	ETF	34.85	34.94	34.81	34.94	53200.0
2009-07-13 08:00:00	QQQ	ETF	34.94	35.07	34.94	35.07	330081.0
2009-07-13 08:30:00	QQQ	ETF	35.07	35.15	35.06	35.07	311620.0
2009-07-13 09:00:00	QQQ	ETF	35.07	35.09	34.97	34.97	487019.0
2009-07-13 09:30:00	QQQ	ETF	34.95	35.02	34.52	34.63	21039593.0
2009-07-13 10:00:00	QQQ	ETF	34.62	34.82	34.48	34.8	11289807.0
2009-07-13 10:30:00	QQQ	ETF	34.8	35.13	34.8	35.13	9960990.0
2009-07-13 11:00:00	QQQ	ETF	35.13	35.16	35.06	35.14	5605935.0
2009-07-13 11:30:00	QQQ	ETF	35.14	35.49	35.14	35.41	16207396.0
2009-07-13 12:00:00	QQQ	ETF	35.42	35.45	35.32	35.3801	4661616.0
2009-07-13 12:30:00	QQQ	ETF	35.39	35.44	35.33	35.33	3281904.0
2009-07-13 13:00:00	QQQ	ETF	35.33	35.5	35.3	35.4715	4502011.0
2009-07-13 13:30:00	QQQ	ETF	35.48	35.48	35.4	35.4399	3212637.0
2009-07-13 14:00:00	QQQ	ETF	35.44	35.57	35.4	35.5	5860323.0
2009-07-13 14:30:00	QQQ	ETF	35.498	35.52	35.42	35.47	5208225.0

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

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