PREVIEW / etf_30min / 2008-05-16

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-05-16.parquet
  size:    165 KB
  rows:    5,699

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
2008-05-16 04:00:00	SPY	ETF	142.53	142.68	142.53	142.68	1300.0
2008-05-16 05:00:00	SPY	ETF	142.9	142.9	142.9	142.9	100.0
2008-05-16 05:30:00	SPY	ETF	142.93	142.95	142.93	142.95	12500.0
2008-05-16 06:00:00	SPY	ETF	142.94	142.96	142.94	142.96	2100.0
2008-05-16 06:30:00	SPY	ETF	142.89	143.03	142.89	142.98	106600.0
2008-05-16 07:00:00	SPY	ETF	143.0	143.0	142.75	142.77	322150.0
2008-05-16 07:30:00	SPY	ETF	142.8	142.86	142.77	142.77	159410.0
2008-05-16 08:00:00	SPY	ETF	142.77	143.0	142.66	142.68	1439137.0
2008-05-16 08:30:00	SPY	ETF	142.71	143.03	142.68	142.96	1607083.0
2008-05-16 09:00:00	SPY	ETF	142.98	142.98	142.75	142.86	1666738.0
2008-05-16 09:30:00	SPY	ETF	142.86	142.87	142.3	142.35	24528641.0
2008-05-16 10:00:00	SPY	ETF	142.36	142.43	141.96	142.3	32755491.0
2008-05-16 10:30:00	SPY	ETF	142.3	142.5397	141.79	141.81	21992235.0
2008-05-16 11:00:00	SPY	ETF	141.81	141.87	141.61	141.74	11920921.0
2008-05-16 11:30:00	SPY	ETF	141.74	142.07	141.68	141.91	10666158.0
2008-05-16 12:00:00	SPY	ETF	141.9	142.14	141.78	142.1	7551030.0
2008-05-16 12:30:00	SPY	ETF	142.11	142.31	142.01	142.2399	7541196.0
2008-05-16 13:00:00	SPY	ETF	142.22	142.38	142.1	142.23	10194491.0
2008-05-16 13:30:00	SPY	ETF	142.23	142.28	141.97	142.17	9365501.0
2008-05-16 14:00:00	SPY	ETF	142.17	142.5389	141.99	142.22	13002530.0
2008-05-16 14:30:00	SPY	ETF	142.22	142.7317	142.13	142.44	11056101.0
2008-05-16 15:00:00	SPY	ETF	142.44	142.76	142.34	142.6	14137285.0
2008-05-16 15:30:00	SPY	ETF	142.61	142.8	142.23	142.65	15088302.0
2008-05-16 16:00:00	SPY	ETF	142.69	142.77	142.0	142.65	4201313.0
2008-05-16 16:30:00	SPY	ETF	142.65	142.7	142.64	142.66	2621677.0
2008-05-16 17:00:00	SPY	ETF	142.66	142.73	142.66	142.73	55200.0
2008-05-16 17:30:00	SPY	ETF	142.66	142.69	142.66	142.69	227700.0
2008-05-16 18:00:00	SPY	ETF	142.69	142.69	142.68	142.69	5363.0
2008-05-16 18:30:00	SPY	ETF	142.69	142.72	142.69	142.72	21737.0
2008-05-16 19:00:00	SPY	ETF	142.72	142.72	142.72	142.72	5700.0
2008-05-16 19:30:00	SPY	ETF	142.75	142.78	142.73	142.76	2305.0
2008-05-16 04:00:00	QQQ	ETF	49.99	49.99	49.98	49.98	200.0
2008-05-16 04:30:00	QQQ	ETF	50.04	50.04	50.04	50.04	100.0
2008-05-16 06:30:00	QQQ	ETF	50.1	50.11	50.1	50.11	1100.0
2008-05-16 07:00:00	QQQ	ETF	50.11	50.13	50.04	50.04	153190.0
2008-05-16 07:30:00	QQQ	ETF	50.05	50.05	50.04	50.05	45300.0
2008-05-16 08:00:00	QQQ	ETF	50.04	50.04	49.96	50.01	799435.0
2008-05-16 08:30:00	QQQ	ETF	50.02	50.09	50.01	50.04	1720376.0
2008-05-16 09:00:00	QQQ	ETF	50.05	50.09	50.01	50.09	1202880.0
2008-05-16 09:30:00	QQQ	ETF	50.09	50.11	49.8	49.83	19596843.0
2008-05-16 10:00:00	QQQ	ETF	49.83	49.87	49.61	49.71	12373179.0
2008-05-16 10:30:00	QQQ	ETF	49.71	49.8	49.57	49.57	8645272.0
2008-05-16 11:00:00	QQQ	ETF	49.57	49.58	49.45	49.56	9512577.0
2008-05-16 11:30:00	QQQ	ETF	49.57	49.75	49.5	49.7	7375619.0
2008-05-16 12:00:00	QQQ	ETF	49.7	49.77	49.63	49.77	5762077.0
2008-05-16 12:30:00	QQQ	ETF	49.76	49.88	49.65	49.859	9101479.0
2008-05-16 13:00:00	QQQ	ETF	49.84	49.88	49.76	49.8	6886515.0
2008-05-16 13:30:00	QQQ	ETF	49.7919	49.8	49.59	49.7001	13657335.0
2008-05-16 14:00:00	QQQ	ETF	49.7	49.85	49.65	49.8	4837872.0
2008-05-16 14:30:00	QQQ	ETF	49.8	49.91	49.77	49.87	6269078.0

> showing 50 of 5,699 rows — these rows as CSV

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